SQL Plus - How do you set AutoComit off for DDL commands in Oracle Server? Is this Possible..?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 100 of 132

How do you set AutoComit off for DDL commands in Oracle Server? Is this Possible..?

Total Answers and Comments: 4

Last Update: August 12, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Rampraas

Not Possible.

Above answer was rated as good by the following members:
neenaceleste

March 28, 2006 08:51:07

Rampraas

Member Since: March 2006 Contribution: 4

RE: How do you set AutoComit off for DDL commands in ...

Not Possible.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 07, 2006 06:21:43

rampratap409

Member Since: September 2006 Contribution: 111

RE: How do you set AutoComit off for DDL commands in ...

For DDL commands you can set auto commit off.

auto commit off: refers to setting the option incase your session got some problem before completing the query then oracle instace will wait for time set by dba and look for setting ( auto commit on/off) accordingly it will perform the action.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

June 17, 2008 07:34:32

lovely sethii

Member Since: June 2008 Contribution: 3

RE: How do you set AutoComit off for DDL commands in Oracle Server? Is this Possible..?

by using set autocommit on we can do it

Is this answer useful? Yes | No

0 1

Overall Rating: -1

August 12, 2008 06:40:27

vishakha_jain81

Member Since: August 2008 Contribution: 6

RE: How do you set AutoComit off for DDL commands in Oracle Server? Is this Possible..?

For DDL commands We cannot do autocommit off. It is modify structure of database object such as table view and these commands have automatically commit.

Set autocommit on/off is used for DML.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank