Answer Posted / su
we can use USER_INDEXES or DBA_INDEXES
sql> desc user_indexes
index_name
index_type
table_owner
table_name
table_type
and plenty of other columns
sql>SELECT index_name
FROM user_indexes
WHERE table_name = 'EMP';
will give us the index_name, which is how we identify an
index
:) hope this helps
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to import one table back from a dump file?
Explain the use of inctype option in exp command.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are the differences between char and varchar2 in oracle?
What is primefaces used for?
How to unlock the sample user account in oracle?
Differentiate between function and procedure in oracle.
How to create lov dynamically at runtime & attach to text field?
Please explain drop constraint oracle?
Is postgres faster than oracle?
how to handle exceptions in post production
How to run the anonymous block again?
What is the relation of a user account and a schema in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is merge in oracle?