Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve data from an explicit cursor?
- 0 Answers
- 1105 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
List out the difference between commit, rollback, and savepoint?
Explain the use of ignore option in imp command.
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 a nvl function? How can it be used?
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>
Why do we use bulk collect in oracle?
1.display list of all users from ur data base.what is the query?
what is the syntax of ALTER command?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
How to pass a parameter to a cursor in oracle?
What is forall Statement ?
Oracle General 
