Interested to Buy Any Domain ? << Click Here >> for more details...
i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?
- 5 Answers
- 7794 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shrikant
After any DDL statement commit will happen by default. So
after any DML statement if you execute DDL satement then
everything is commited.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / debashish mohanty
1.After Successful table creation the deletion are not be committed.
2.Delete is a DML operation its not auto committed.
3.There is no dependency between deleting rows and creation of table.
4.May be the Question is totally wrong else am Screwed to answer this kind of Questions.
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / mohit singla
Deletion won't be commit. Also if our table is created
successfully and we are using rollback even then it won't
fetch the delete statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the use of rows option in exp command.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
what is the output of select * from emp where null=null & select * from emp where 1=1
How to bring a tablespace offline?
How to fetch the row which has the max value for a column?
What is oracle update statement with inner join ?
What are the general rules on data consistency?
What is a Temporary Segment ?
What is forall Statement ?
How to see the table columns used in an index?
Will you be able to store pictures in the database?
How to drop an index in oracle?
Oracle General 
