Interested to Buy Any Domain ? << Click Here >> for more details...
How do we know whether an index is created on a table ???
- 2 Answers
- 5867 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / urmi
select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');
| Is This Answer Correct ? | 0 Yes | 0 No |
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
What are the commands youd issue to show the explain plan for select
How to Identify the previously inserted/updated records in already populated table.
which is the best training centre for learning oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
what is the difference between rollback & commit? can a foreign key has null value?
what is analyze command ? what kind of statistics does it generate?
What WHERE CURRENT OF clause does in a cursor?
Does oracle charge for java?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
how to clone 9i Database on to 10g Database.
How to get the Installed Oracle Version Information ?
Oracle General 
