Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5809 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 |
How to use "while" statements in oracle?
Explain about functional dependency and its relation with table design?
What is oracle instant client?
which clause we are not used in where clause?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
what is the syntax of DELETE command?
What is a sub query and what are the different types of subqueries?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to install oracle odbc drivers?
What are the components of Logical database structure of ORACLE database?
How to check the oracle tns settings?
What is mean by Program Global Area (PGA) ?
Oracle General 
