how the Oracle Prepares the Execution Plan and how it
chooses the Optimal one?
No Answer is Posted For this Question
Be the First to Post Answer
What is snapshot is too old? Give and example for better understand.
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
Explain enable novalidate constraint.
What is a package in oracle?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
Is rowid unique in oracle?
how to see the data (in unix) using dataset in datastage?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
how to retrieve 1st and last row of table without using group functions??
What are the uses of linked server and explain it in detail?
What is hot backup and logical backup?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.