mamta_dharmik

 Profile Answers by mamta_dharmik Questions by mamta_dharmik

• Sep 21st, 2006

 

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

Varun Dixit

• Oct 4th, 2006

 

Hi

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

shwetadubey

 Profile Answers by shwetadubey 

• Oct 6th, 2006

 

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

Varun Dixit

• Nov 10th, 2006

 

Hi Shweta,

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

nabajit_oracle

• Mar 5th, 2007

 

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