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 you find out version of installed workflow?
What is an index associated with a constraint?
How to execute a stored procedure in oracle?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
What is the difference between view and materialized view in Oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the difference between a primary key & a unique key?
What are set operators?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
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.