Write the use of the Savepoint command with an example.
Advertisements
प्रश्न
Write the use of the Savepoint command with an example.
Advertisements
उत्तर
The SAVEPOINT command is used to temporarily save a transaction so that you can roll back to the point whenever required. The different states of our table can be saved at any time using different names and the rollback to that state can be done using the ROLLBACK command.
SAVEPOINT savepoint_name;
UPDATE Student SET Name = ‘Mini ’ WHERE Admno = 105;
SAVEPOINT A;
APPEARS IN
संबंधित प्रश्न
The command to delete a table is ______
The clause used to sort data in a database.
Which component of SQL lets inserts values in tables and which lets to create a table?
Write a short note on Primary key constraints.
Write a SQL statement to modify the student table structure by adding a new field.
Write the different types of constraints and their functions.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To add a new row.
Consider the following employee table. Write SQL commands for the question.
| EMP CODE | NAME | DESIG | PAY | ALLO WANCE |
| S1001 | Hariharan | Supervisor | 29000 | 12000 |
| P1002 | Shaji | Operator | 10000 | 5500 |
| P1003 | Prasad | Operator | 12000 | 6500 |
| C1004 | Manjima | Clerk | 8000 | 4500 |
| M1005 | Ratheesh | Mechanic | 20000 | 7000 |
To display the details of all employees who are operators.
Construct the following SQL statement in the student table-
SELECT statement using GROUP BY clause.
Construct the following SQL statement in the student table-
SELECT statement using ORDER BY clause.
