Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5869 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to export data to a csv file?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is an oracle user account?
List the parts of a database trigger.
What are the differences between interval year to month and interval day to second?
What is archive log in Oracle?
What is MTTR advisor in Oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What to do if the binary spfile is wrong for the default instance?
What privilege is needed for a user to connect to oracle server?
Explain the use of consistent option in exp command.
How do I uninstall oracle client from windows?
Explain constraining triggers.
Why cursor variables are easier to use than cursors?
What happens to indexes if you drop a table?
