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
- 7563 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 types of exception?
How do we display rows from the table without duplicates?
How many types of synonyms in Oracle?
what is the use of system.effective.date variable in oracle?
What is the quickest way to export a table to a flat file?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is tns service name?
What is a OUTER JOIN?
what is exact difference between drop and truncate table.
Calculate difference between 2 date / times in oracle sql?
How to call a sub procedure?
How to define and use table alias names in oracle?
Oracle General 
