How do we display rows from the table without duplicates?
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.
How to turn on or off recycle bin for the instance?
What is the difference between an Oracle Schema and an Oracle Instance?
What is a table index?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
How to shutdown your 10g xe server from command line?
What is difference between sid and service name in oracle?
How to handle a single quote in oracle sql?
Explain the use of full option in exp command.
What are the original export and import utilities?
How do I spool in oracle?
What is the simplest tool to run commands on oracle servers?