|
| Total Answers and Comments: 8 |
Last Update: September 12, 2007 |
|
| | |
|
Submitted by: Indu
select - data retrieval insert, update, delete, merge - DML Create, alter, drop, rename, truncate - DDL Commit, rollback, savepoint - transaction control grant, revoke - DCL
Above answer was rated as good by the following members: ashaRane | |
September 15, 2005 07:39:05 | #4 |
| Indu |
|
Member Since: September 2005 Contribution: 2 |
RE: What are the types of SQL statement
| select - data retrieval insert, update, delete, merge - DML Create, alter, drop, rename, truncate - DDL Commit, rollback, savepoint - transaction control grant, revoke - DCL |  | | Is this answer useful? Yes | No | 1 0 | Overall Rating: +1 |
|
| |
|
October 15, 2005 04:29:32 | #5 |
| annathurai |
|
|
RE: What are the types of SQL statement
| data defination lanugae: 1) create new table creation create new table from existing table fields 2)alter i) add table ii)modify table iii)Drop table iii)rename the table data manipulation language update insert delete truncate data transaction language commit rollback save point lock it consists of table and row level |  | | Is this answer useful? Yes | No | | |
|
| |
|
April 21, 2006 05:25:28 | #6 |
| Narayana |
|
|
RE: What are the types of SQL statement
| DDL - create, drop, etc., DML - Select, Insert, Update, Delete, etc., DCL - Grant, Revoke, etc., TCL -Savepoint, commit, Rollback, etc., |  | | Is this answer useful? Yes | No | | |
|
| |
|
January 21, 2007 23:55:20 | #7 |
| kshsingh1 |
|
Member Since: November 2005 Contribution: 3 |
RE: What are the types of SQL statement
| There are Basically 5 types of SQL Statement Data Manipulation Statements Data Definition Statements Transaction Control Statements Session Control Statements System Control Statements |  | | Is this answer useful? Yes | No | | |
|
| |
Go To Top
|