Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5777 Views
- TCS, I also Faced
- E-Mail Answers
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 |
what is shell?
How to check your oracle database 10g xe installation?
Explain the use of online redo log files in oracle.
What are the data types in oracle?
What are the components of Logical database structure of ORACLE database?
13. Display the second to fifth characters in each client name.
What does ROLLBACK do ?
What is flashback in Oracle?
What is the difference between I and G in Oracle?
What is the relation of a user account and a schema in oracle?
How to define and use table alias names in oracle?
How will you identify oracle database software release?
Oracle General 
