Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5654 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 |
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Explain oracle instance.
What is a package ? What are the advantages of package ?
Explain the use of indexes option in imp command.
What is a user account in oracle?
How to initialize variables with default values?
What is a server parameter file in oracle?
Why packages are used in oracle?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
How do you rate yourself in oracle and sql server ?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
Oracle General 
