Friday 6 December 2013

What r the different types of SQL statements?

The tables in the following sections provide a functional summary of SQL commands and are divided into these categories:
1.     Data Definition Language commands (CREATE, ALTER, and DROP)
2.     Data Manipulation Language commands (SELECT, INSERT, UPDATE, LOCK TABLE)
3.     Transaction Control commands (COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION)
4.     Session Control commands (alter session, set role)
5.     System Control commands (alter system)
6.     Embedded SQL commands (ALLOCATE, CLOSE, DECLARE CURSOR, CONNECT, DECLARE DATABASE, DECLARE STATEMENT, DECLARE TABLE, DESCRIBE, EXECUTE, FETCH, OPEN, WHENEVER)

No comments:

Post a Comment