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
- 6778 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 |
am completed mca2011 how get certification in oracle
How can we Update a table with out using UPDATE command?
List the various oracle database objects?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
How to omit columns with default values in insert statement in oracle?
Explain the difference between replace() and translate() functions in oracle?
Is truncate autocommit in oracle?
What is an Index Segment ?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
Differentiate between translate and replace?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How to use fetch statement in a loop?
Oracle General 
