What is the relationship among database, tablespace and data file?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between translate and replace in oracle?
Explain an index?
How to add a new column to an existing table with a default value?
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 data independence exactly? give an example
Explain the use of Merge statement in oracle 11g
what is Table ?
what happened to the global index when I truncate the data in one of the partition?
State the various uses of dbcc command?
What are the attributes of cursor?
What is bulk copy or bcp in oracle?
What is an oracle user account?