Explain the commit statement.



Explain the commit statement...

Answer / Shabnam Parween

"The commit statement in SQL (PL/SQL) is used to save or persist all the changes made to a database. Once a commit statement is executed, the changes are saved and cannot be undone unless rolled back."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is NOCOPY?

6 Answers   DELL,


List the various privileges that a user can grant to another user?

1 Answers  


What is procedure and function in sql?

1 Answers  


Where the integrity constrints are stored in Data Dictionary?

1 Answers  


what is an alias command? : Sql dba

1 Answers  


What is dynamic sql in pl sql?

1 Answers  


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  


how can we destroy the cookie? : Sql dba

1 Answers  


What is a pragma statement?

1 Answers  


How to know the last executed procedure?

1 Answers  


Does sql support programming?

1 Answers  


Can you have more than one trigger on a table?

1 Answers  


Categories