How to create a table index?
- 1 Answers
- 1274 Views
- I also Faced
- E-Mail Answers
Answer / Rajendra Prasad Meena
"To create an index on a table, use the CREATE INDEX statement with the name of the index, the name of the table, and the column or columns to be indexed. For example: CREATE INDEX idx_name ON table_name (column_name)."n
| Is This Answer Correct ? | 0 Yes | 0 No |
How many file formats are supported to export data?
How many types of tables supported by oracle?
How to rollback the current transaction in oracle?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to rename an index in oracle?
What are the types of trigger in oracle?
What is the usage of analyze command in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the use of consistent option in exp command.
Explain enable novalidate constraint.
How to write a query with a right outer join in oracle?
What happens to indexes if you drop a table?
Oracle General 
