Interested to Buy Any Domain ? << Click Here >> for more details...
What does COMMIT do ?
- 4 Answers
- 10537 Views
- I also Faced
- E-Mail Answers
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 |
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
What are the logical operations?
How to display the hierarchy of employee and managers without using connect by prior.
What is the sid in oracle?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Explain cascading triggers.
Write a simple Store procedure and pass parameter to it ?
what is foreign key?
What does COMMIT do ?
What is the data type of dual table?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
Oracle General 
