How to get a list of all user accounts in the database?
No Answer is Posted For this Question
Be the First to Post Answer
How to sort output in descending order in oracle?
How to save query output to a local file?
How many types of database triggers exist?
State any two functions of oracle?
How do you store pictures in a database?
What is the diff between Oracle and SQL Server
How do we represent comments in oracle?
What is an anonymous block?
What are inner join and outer join?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is Public Database Link ?
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.