29-04-2014, 12:11 PM
STUDY OF SPECIAL SQL COMMANDS
AIM
To execute and verify the Special SQL commands.
PROCEDURE
STEP 1: Start
STEP 2: Create the table with its essential attributes.
STEP 3: Insert attribute values into the table
STEP 4: Execute different Commands and extract information from the table.
STEP 5: Stop
SQL COMMANDS
1. COMMAND NAME: COMMIT
COMMAND DESCRIPTION: COMMIT command is used to save the work done.
2. COMMAND NAME: SAVE POINT
COMMAND DESCRIPTION: SAVE POINT command is used to identify a point in a
transaction in which it can be restored using Roll back command.
3. COMMAND NAME: ROLLBACK
COMMAND DESCRIPTION: ROLLBACK command is used to restore database to original
since last commit.
4. COMMAND NAME: MAX
COMMAND DESCRIPTION: MAX command is used to find the maximum among the
entities in a particular attribute.