What are a cluster and non-cluster index?
No Answer is Posted For this Question
Be the First to Post Answer
how to select second mauximum value in a given table under salary column
What is the maximum limit on the number of columns in a table?
how to find find & delete duplicate rows from two different tables?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
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.
How do I find my oracle client driver version?
Explain the use of record length option in exp command.
What is a cognitive schema?
how to genarate random numbers in oracle for particular row?
What is a read write transaction in oracle?
What is oracle update statement with inner join ?
Please explan Why static query is more faster than dynamic query ?