How do we know whether an index is created on a table ???
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
Explain the use of rows option in exp command.
What are the different types of failures that occur in Oracle database?
How to call a stored function with parameters?
Explain a private synonyms?
How to shutdown your 10g xe server?
What are the benefits of ordbms?
How to define a variable to match a table column data type?
How to change system global area (sga) in oracle?
Is oracle a programming language?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
State and explain about oracle instance?
How to use attributes of the implicit cursor in oracle?
How to drop a tablespace?
Can we call procedure inside function in oracle?