can we create index on index?

Answer Posted / ramaraju

No, once we will try to create index on index we will get this error
ERROR at line 1:
ORA-01408: such column list already indexed

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain isolation levels. : Transact sql

741


What is dialect in sql?

700


What is query execution plan in sql?

771


State some properties of relational databases?

755


What is the source code of a program?

704






Enlist some predefined exceptions?

795


what is transaction? : Sql dba

717


how would you enter characters as hex numbers? : Sql dba

713


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

770


What is a parameter query?

817


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6584


How is sql used in oracle?

755


Is left join faster than join?

760


What is indexing oracle sql?

744


How delete all records from table in sql?

719