Radha

• Jul 13th, 2011

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...

murthy 1053

 Profile Answers by murthy 1053 Questions by murthy 1053

• Jul 2nd, 2010

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.

Answer Question  Select Best Answer

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.

sububhaai

 Profile Answers by sububhaai Questions by sububhaai

• May 14th, 2009

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.

Answer Question  Select Best Answer