what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 7910 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya ramesh
grant - it is a statement of DCL (DATA CONTROL LANG)
granting previleges to the user
Commit,Rollback and savepoint are the statements of TCL (TRANSACTION CONTROL LANG)
Commit - Makes a permanent change to the data in the database
Rollback - The changes made in the data can be undone using roll back statement
savepoint - The point upto which the data can be commited while the rest of the datas can be rollbacked as necessary
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can triggers stop a dml statement from executing on a table?
How many triggers can be applied to a table?
Why do we use joins in sql?
How does sql developer connect to oracle database?
What is trigger and stored procedure in sql?
What is minus?
when is the use of update_statistics command? : Sql dba
What does where 1 1 mean in sql?
what is single byte over head in oracle..?
Can I create table without primary key?
Define implicit and explicit cursors.
What are actual parameters and formal parameters?
What is a database event trigger?
Is sql free?
What is full join in sql?
