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
Powered by Blogger.