How do we know whether an index is created on a table ???
Answer Posted / 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 |
Post New Answer View All Answers
How to delete a column in an existing table?
Why do you use stored procedures and state some of its disadvantages?
What are a query and state the different types of queries and their uses?
What is the dynamic sql in oracle?
How to write a left outer join with the where clause in oracle?
What is different types of joins?
What is the best way to do multi-row insert in oracle?
When do you get a .pll extension in oracle? Explain its importance
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is meant by raw datatype?
How do I spool in oracle?
How data locks are respected in oracle?
How is it different from a normal table?
What is an oracle user account?
What is Reduced List of Values?