what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / anjani kumar
Commits and Rollback both complete our transaction cycle.
we use commit to store the DML changes into DB but Rollback
performs undo to our DML transaction
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
what is meant by magic query
Explain the features of oracle?
What is dual table oracle?
Explain drop constraint oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the use of rows option in imp command.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to add a new column to an existing table with a default value?
What is concurrency in oracle?
Explain a private synonyms?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is merge statement used for?
What are the attributes of cursor?
How remove data files before opening a database?