How to recover a dropped index?
Answer / rajmohan
The index would come back but the name doesn't get changed and keeps the system name.
You can see that the index is there but didn't recover its original name.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a package ? What are the advantages of package ?
How can you Enforce Referential Integrity in snapshots ?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
how to produce numbers from 1 to 10 using dual table
can a table has a column that has only view data and in other columns we can change data?
What is an oracle transaction?
What is the difference between a primary key & a unique key?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
What is translate in oracle?
What is a Sequence ?
How to write a query with a right outer join in oracle?
How to define an external table with a text file?