Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5659 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer / 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 |
How to connect to a remote server?
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 a system tablespace and when it is created?
Define 'view' advantage ?
What are the varoius components of physical database structure of oracle database?
Explain the use of consistent option in exp command.
What is meant by an index?
What is an oracle function?
Which environment variables are absolutely critical in order to run the OUI?
various types of joins
what is the exact diiference between DBMS and RDBMS
How to loop through data rows in the implicit cursor?
Oracle General 
