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 |
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
what are Triggers?
How will you write a query to get a 5th rank student from a table student_report?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
What is the usage of save points in oracle database?
What is a subquery?
What is a Synonym ?
what is the syntax of UPDATE command?
What are the logical operations?