How do we know whether an index is created on a table ???
Answers were Sorted based on User's Feedback
Answer / anithaletchumi
select index_name from dba_indexes where table_name=upper
('table_name');
dba_indexes -> This view has the description for all
indexes in the database.
Is This Answer Correct ? | 6 Yes | 5 No |
Answer / urmi
select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the concept of the DUAL table.
what is the difference between functional dependecy and multilevel dependency?
How can I introduce multiple conditions in like operator?
Differentiate between pre-select and pre-query?
How to shutdown your 10g xe server?
Explain temporal data types in oracle
State the difference between a primary key and foreign key?
How to assign query results to variables?
How to enter a new row into a table interactively?
What is an oracle database table?
Explain integrity constraints?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?