Answer Posted / pravin patil
Vies is logical representaion of parent table
& index is oralce object use to access table' column quickly
view can replace but index cannot replace u have to delect
existed index then create new index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do I uninstall oracle client from windows?
What are the oracle differences between nvl and coalesce
What is blob data type in oracle?
Explain an exception?
How many data types are supported?
Why does Oracle not permit the use of PCTUSED with indexes?
What is object data modeling?
Calculate difference between 2 date / times in oracle sql?
Why do we need integrity constraints in a database?
Is a rollback possible to any savepoint?
What is a nested table?
What do you know about normalization? Explain in detail?
How to execute a stored procedure in oracle?
What is oracle in java?
How to delete multiple rows from a table in oracle?