Do you need a commit after DDL statements?

  • Interview Candidate
  • 9
  • 12357

Showing Answers 1 - 9 of 9 Answers

sangeeta

  • Jun 1st, 2005
 

no by default it will commit

  Was this answer useful?  Yes

LAKSHMAN CHOWDARY

  • Oct 17th, 2005
 

DDL IS A AUTO COMMIT YOU NEED NOT COMMIT AGAIN

  Was this answer useful?  Yes

Chiranjeevi Manne

  • Nov 9th, 2005
 

No Need

  Was this answer useful?  Yes

Raman

  • Dec 17th, 2005
 

DDL is auto commited, ne need to give aditional Commit command.   

  Was this answer useful?  Yes

sambaiah chowdary Ponnekanti

  • Feb 2nd, 2006
 

   Dear friends

         Wherever we execute or run any DDL statements that is modified and stored directly in datafiles. thats why there is no need to use COMMIT statement after running the DDl satements.

  Thanking u my friends 

         

  Was this answer useful?  Yes

apiplani

  • Feb 12th, 2006
 

No you dont need to call a commit after a DDL statement. Indeed once you give a DDL command all the un-commited DML statements also get committed. A DDL statement on completion calls an explicit Commit.

  Was this answer useful?  Yes

SUBBU M

  • May 25th, 2006
 

 Dear Mam/Sir ,

NO NEED TO COMMIT AGAIN USING DDL STATEMENTS .

  Was this answer useful?  Yes

cmanne

  • Mar 25th, 2007
 

There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically

  Was this answer useful?  Yes

Chintan

  • May 29th, 2012
 

DDL is Auto Commited Statements.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions