What does COMMIT do ?

Answer Posted / sikdar

Commit is a TCL command which is used to make database
transaction parmanent.

The data is commited but it can't be rollbacked.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to count groups returned with the group by clause in oracle?

844


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1737


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2032


Will you be able to store pictures in the database?

902


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1815


How many types of cluster table in Oracle?

803


How to build data dictionary view an new database?

796


What is query image?

766


What is blob datatype?

791


what is the scenario where you take the database to NoArchivelog mode?

2072


What happens if you set the sga too low in oracle?

812


State all possible different index configurations a table can possibly have?

789


Explain rename?

750


Explain the use of consistent option in exp command.

755


How to best split csv strings in oracle 9i?

801