What does ROLLBACK do ?
It is used to undo the work performed by the current transaction.
Is This Answer Correct ? | 0 Yes | 0 No |
how to produce numbers from 1 to 10 using dual table
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How to create an oracle database?
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 meant by magic query
How to use subqueries with the exists operator in oracle?
what is the syntax of INSERT command?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
What is the purpose of a cluster?
What are the restrictions on external table columns?
What are the predefined tablespaces in a database?
What is a Database instance ? Explain?