How to install oracle database 10g xe?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a user and a schema in oracle?
What is blob datatype?
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.
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How would you optimize a slow SQL query?
What is a nested table?
What is the scope of a local variable?
How many types of tables supported by oracle?
How do I start tns listener?
How to define a cusotmer as a supplier in ORACLE R12
Explain the truncate in oracle?
What is the difference between I and G in Oracle?