SQL Plus - What is the difference between Commit and Go

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 113 of 132

What is the difference between Commit and Go

Total Answers and Comments: 5

Last Update: March 05, 2007 Asked by: Manu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 21, 2006 05:58:58

mamta_dharmik

Member Since: February 2006 Contribution: 7

RE: What is the difference between Commit and Go

COMMIT statement is used to make permanent changes in the table. It is same as save button.

i don't know go statement. but to cancel all the changes made ROLLBACK statement is used. It functions same as undo button

Is this answer useful? Yes | No

October 04, 2006 05:51:21

Varun Dixit

RE: What is the difference between Commit and Go

Some databases like sybase we use 'go' statement as in oracle we use a semicolon to execute the a statement. After execution of a statement changes are not made permanent to the database to make the changes permanent so that even after ending the session next time one logs in one finds the changes made in the previous session; one needs to Commit the changes; so that all the changes are recorded/written/overwritten to the database.

Thanks and Regards

Varun Dixit

Is this answer useful? Yes | No

October 06, 2006 14:38:40

shwetadubey

Member Since: August 2006 Contribution: 2

RE: What is the difference between Commit and Go

hi varun

this is shweta..

m also working in oracle..

can v xchange our mail id's mine is shweta_m_dubey@yahoo.co.in.

(underscore is there between shweta and m )bye

Is this answer useful? Yes | No

November 10, 2006 01:48:55

Varun Dixit

RE: What is the difference between Commit and Go

Hi Shweta

My mail id is varun.dixit@india.birlasoft.com

Is this answer useful? Yes | No

March 05, 2007 06:13:44

nabajit_oracle

RE: What is the difference between Commit and Go

Commit to like making all the changes permanently in the Server...

But in case of GO statement which is available In SQL Server(TSQL) the set of steps before the GO statement is complied at once and sent to server...

I mean from the beginning of the script or any other GO statement(Whichever is closer) all statements are complied into one execution plan and sent to the server independent of the other batches...

Thanks

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank