Oracle Tips
Here are some helpful tips to remember when dealing with oracle.
I. Use the “flashback technology” when you accidentally commit a mistake with your production data.
(altering entire table contents, corrupted table data, or worst dropping unintended table).
- First thing to do is to enable flashback on your database.
ALTER DATABASE FLASHBACK ON;
- Restoring database to its good state.
FLASHBACK DATABASE TO RESTORE POINT bef_damage;
- Restoring dropped table.
FLASHBACK TABLE [TABLE_NAME] TO BEFORE DROP;
- Restoring table to its good state.
FLASHBACK TABLE [TABLE_NAME] TO TIMESTAMP TO_TIMESTAMP('[DATE_TIME]');
II. Manipulate date and time display
Aside from to_date and to_timestamp functions , you could also alter the date and time display in your database through the use of this code below.
ALTER SESSION SET NLS_DATE_FORMAT = '[DATE_FORMAT]'
