Flash Back query is used to get back the deleted rows & dropped tables from the database even they are
committed.
To get back the dropped table:
Flashback table to before drop;
To get back...
Flash back query is used to retrive the data.For ex if a table is dropped and we want the table again so at that time.syn:=FLASHBACK TABLE table_name TO BEFORE DROP.This will work only if recycled bin is not purged.
List at least three common ways to write logs in PL SQL?
yogesh
Aug 4th, 2011
We can't return more than 1 value in function but by using OUT parameter we can get multiple values in function
which is not good programming, by using ref cursor we just save memory location of function doesn't return more than 1 value.
1. Create a log table and insert your logging messages into this table.2. Write to a log file, using the DBMS_FILE package, but this is not recomended because there is lot of I/O.