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
- 7765 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 |
What do you mean by merge in oracle and how can we merge two tables?
After update how do u know how many records got updated
Can a Tablespace hold objects from different Schemes ?
What are the benefits of ordbms?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to assign values to variables?
What is a select query statement in oracle?
How do I spool in oracle?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
What is connection pooling in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is an Index ? How it is implemented in Oracle Database ?
Oracle General 
