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 to define an anonymous block?
What is a database table in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the dynamic sql in oracle?
Is oracle a language?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is oracle and what are its different editions?
How to call a stored function in oracle?
What is a Segment ?
What are the different types of database objects?
How to rename an index?
Please explain joins in oracle?