Whats the benefit of dbms_stats over analyze?
- 0 Answers
- 1505 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is index in Oracle?
What is system tablespace?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Can a parameter be passed to a cursor?
State the various uses of dbcc command?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is a directory object?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
what is the dual table in oracle?
How to delete multiple rows from a table in oracle?
How to bring a tablespace offline?
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.
Oracle General 
