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 |
What do you know about normalization? Explain in detail?
List the types of joins used in writing subqueries?
What is max rowid in oracle?
Explain coalesce function?
How to load a large xml file?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How are the index updates?
How to find out what privileges a user currently has in oracle?
what is null value?
What is connection pooling in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is SAVE POINT ?