How oracle manages dependency between referenced and dependent objects ?

johnjerry

 Profile Answers by johnjerry Questions by johnjerry

• Oct 7th, 2009

We can set REMOTE_DEPENDENCIES_MODE inside init.ora parameter file to TIMESTAMP or SIGNATURE.ALTER SYSTEM SET REMOTE_DEPENDENCIES_MODE = [TIMESTAMP|SIGNATURE]

YugundharK

 Profile Answers by YugundharK Questions by YugundharK

• Oct 13th, 2008

Oracle manages dependency between referenced and dependent objects by using 2 modes1. Timestamp mode2. Signature mode

Answer Question  Select Best Answer

Assume that I am using a temporary table in a procedure and I am inserting records and updating another set of records through Merge statement. If I use cursor in that temporary table, How can I extract all of the records from temporary table at the end of the stored procedure. Can you please give coding for this.

johnjerry

 Profile Answers by johnjerry Questions by johnjerry

• Oct 7th, 2009

Make sure you do not COMMIT* in the middle of the procedure. You can do any number of insertion into and deletion from temporary table and use "Select * from temp_table" to fetch a...

priyanka jolly

• Nov 24th, 2007

Create Global temporary tables and say on commit preserve rows. The global temporary tables have data available till the session is active. So you if you insert it at one procedure and want to access it somewhere else you can do that very easily till the session is activeThanks Priyanka

Answer Question  Select Best Answer

PRADEEP

• Oct 16th, 2012

Rowid is octal decimal values it is stored permanently in a oracle database. It will created while creating a table.

rownum is also octal decimal number but it is for only specific time span it will arise after completed a task.

Dilip

• Sep 3rd, 2012

Here I am providing all the psudo columns of Oracle ROWNUM, ROWID,NEXTVAL, CURRVAL, SYSDATE, USER, LEVEL

Answer Question  Select Best Answer