What does COMMIT do ?
Answers were Sorted based on User's Feedback
Answer / guest
COMMIT makes permanent the changes resulting from all SQL
statements in the transaction. The changes made by the SQL
statements of a transaction become visible to other user
sessions transactions that start only after transaction is
committed.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kiran
when ever a user performs commit action , the data is
permanently written the the tablespace and cannot be rolled
back
after performing the commit operation , the users in other
user sessions can view only the committed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / annu rajput
Commit is a TCL command which is used to make database
transaction parmanent.
one the data is commited it can't be rollbacked.
Thanks
Annu Rajput
| Is This Answer Correct ? | 5 Yes | 3 No |
how will I find the first 5 highest salaried employees in each dept in oracle.
How to get a list of all background sessions in the database?
What is a parameter file in oracle?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
How to open and close an explicit cursor in oracle?
what is the difference between restoring and recovering?
Explain oracle instance.
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
how to retrieve 1st and last row of table without using group functions??
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
How view is different from a table?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?