i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?
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 is a table in oracle?
What language does oracle use?
Select the Nth lowest value from a table?
difference between imlicit cursor and explicit cursor ?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is define in oracle?
Explain what are the advantages of views?
How to filter out duplications in the returning rows using oracle?
How do you find current date and time in oracle?
What is the difference between SQL and SQL Server?
What is the difference between pre-select and pre-query?
How do I find my oracle client driver version?