Interested to Buy Any Domain ? << Click Here >> for more details...
what is d diff between grant,commit,rollback n savepoint
- 1 Answers
- 8446 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
what is data control language? : Sql dba
Explain the difference between sql and mysql.
Can we commit in trigger?
What is the difference between delete, truncate and drop command?
Why is pl sql used?
Is left join same as join?
What is substitution variable?
how to include numeric values in sql statements? : Sql dba
What are the set operators in sql?
How do you break a loop in pl sql?
What is cursor status?
explain the delete statements in sql
What is the purpose of the partition table?
Why self join is used in sql?
Does sql support programming?
