How can you Enforce Referential Integrity in snapshots ?
Answer / nishi
Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many memory layers are in the oracle shared pool?
How to create a server parameter file?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
What is program global area (pga) in oracle?
What is a system tablespace and when it is created?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How is it different from a normal table?
What is rowid and rownum in oracle?
Explain the family trees and connection by clause
Can a primary key contain more than one columns?
How to select the name of employee who is getting maximum sal with out using subquery