Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5976 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 difference between foreign key and reference key
How to get execution statistics reports on query statements?
How do I recompile a procedure in oracle?
Why do you create or replace procedures rather that drop and recreate.
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
How to invoke the data pump import utility?
State the various uses of dbcc command?
What is memory advisor in Oracle?
How to pass a cursor variable to a procedure?
Can multiple cursors being opened at the same time?
How to Remove the 3rd highest salary person record from table?
How to experiment a data lock in oracle?
Oracle General 
