Technical Notes
We're all on the same page!
Showing posts with label
undo
.
Show all posts
Showing posts with label
undo
.
Show all posts
Friday, 30 March 2018
How to do CTAS in Oracle?
›
CTAS stands for Create Table As Select e.g. SQL> CREATE TABLE HR.EMPLOYEES_NEW AS SELECT * FROM HR.EMPLOYEES; -> By defau...
Friday, 21 April 2017
How to restore database object such as package body via flashback?
›
Note that below SQL gets output if it is still in UNDO tablespace. SQL> SELECT text FROM all_source AS OF TIMESTAMP TO_TIME...
›
Home
View web version