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 |
how to retrieve data from different tables ,place this data in different excel worksheets.
How to assign query results to variables?
Can we create more than one constraint to column ?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is clusters ?
How to invoke the data pump import utility?
How to get maxsal , minsal, ename department wise in single query
How to use existing values in update statements using oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is raw datatype in oracle?
How do you tell what your machine name is and what is its IP address?
Can you have more than one content canvas view attached with a window ?