Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5974 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 many file formats are supported to export data?
How to establish administrator authentication to the server?
What are the extensions used by oracle reports?
What is truncate oracle?
Explain an index segment?
What is query image?
What is the difference between translate and replace in oracle?
What are the different oracle database objects?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How can I introduce multiple conditions in like operator?
How many categories of data types?
How view is different from a table?
Explain rename?
Explain oracle left join with an example?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
