Using Auto Generate Mapper with MyBatis.
First time inserting a record, that inserted record ID needed for another transaction. Use this SQL:
SELECT SEQ_USER.CURRVAL FROM DUAL […]
You want to make a temporary (buffer) table which had a same structure and data with original, use this SQL:
CREATE TABLE xyz_new AS
xyz_new is a temporary (buffer) table; xyz is o […]
Clean up your mess with following command
SELECT ‘drop table ‘ || table_name || ‘ cascade constraints;’
Then, copy the resulting text script into sql console, and execute it. […]
When you want to find all duplicate value in table, use this:
(adding more field to find more searching value criteria)
SELECT DISTINCT NAME, EMAIL
GROUP BY NAME, EMAIL
HAVING count(*) […]
Welcome to My Blog!
This my first post!
Gonna post more after this… 🙂
This blog’s purpose is gonna be a Wiki, contains anything related to my works or my hobbies. XD
- Muat lagi