How to display the hierarchy of employee and managers
without using connect by prior.
How to define a sub function?
What do you mean by group by clause?
What is the difference between alert log file and tarce file ?
how to retrieve data from different tables ,place this data in different excel worksheets.
What is a cluster?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to convert characters to times in oracle?
What is a package in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How will you identify oracle database software release?
How to do a full database export?
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.