what is analyze command ? what kind of statistics does it
generate?
Answers were Sorted based on User's Feedback
Answer / mr. chandra
analyze command is used to check the statics of the query
and performance.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brahma prakash
It Analyze the cost of the query with shortest excution path
Is This Answer Correct ? | 0 Yes | 0 No |
What is an Oracle index?
What is the use of oracle?
What is oracle in java?
Explain about integrity constraint?
sql query to get zero records from a table
Why do we need integrity constraints in a database?
How to use fetch statement in a loop?
how to make an oracle object
What is backup in Oracle?
 How to use an oracle sequence generator in a mapping?
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.
Please explain drop constraint oracle?