What is a sub query? What are its various types?
No Answer is Posted For this Question
Be the First to Post Answer
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 STATSPACK tool?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
Define 'view' advantage ?
What do you know about normalization? Explain in detail?
How to save query output to a local file?
Explain drop constraint oracle?
Explain about achiever in sql?
Explain index?
What is the max number of columns in an oracle table?
Explain a segment?
What is the difference between normal and corelated subqueries?