Anurooba Balakrishnan
Answered On : Jun 27th, 2005
Data Manipulation Language
Data Definiton language
transaction control
session control
system control
Login to rate this answer.
sasidhar
Answered On : Aug 4th, 2005
The types of sql statements are DML,DDL,DCL,TCL
Login to rate this answer.
Jagdish
Answered On : Aug 22nd, 2005
There are 3 types of sql stm.
ddl, dml, dtl
Login to rate this answer.
select - data retrieval
insert, update, delete, merge - DML
Create, alter, drop, rename, truncate - DDL
Commit, rollback, savepoint - transaction control
grant, revoke - DCL
2 Users have rated as useful.
Login to rate this answer.
annathurai
Answered On : Oct 15th, 2005
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
Login to rate this answer.
Narayana
Answered On : Apr 21st, 2006
DDL - create, drop, etc.,
DML - Select, Insert, Update, Delete, etc.,
DCL - Grant, Revoke, etc.,
TCL -Savepoint, commit, Rollback, etc.,
Login to rate this answer.
There are Basically 5 types of SQL Statement
Data Manipulation Statements
Data Definition Statements
Transaction Control Statements
Session Control Statements
System Control Statements
Login to rate this answer.
sandhya
Answered On : Sep 12th, 2007
Data Definition Language: Create, Alter
Data Modification Language: Update,insert, Delete, Truncate
Data Control Language: Commit, Rollback
Login to rate this answer.
Data Definition Language.
Data Manipulation Languge.
Data Transaction Control Language.
Data Manipulation Control Language.
Data session control.
Data system control. etc
these are SQL types statements.
Login to rate this answer.
SQL statements can be subdivided into the following six types:
1. Data Definition Language (DDL) statements let you to perform these tasks:
CREATE, ALTER and DROP schema objects
GRANT and REVOKE privileges and roles
Analyze information on a table, index, or cluster
Establish auditing options
Add comments to the data dictionary
2. Data Manipulation Language (DML) statements access and manipulate data in existing schema objects. However, NO automatic commit is done.
Example:
SELECT, INSERT, UPDATE, DELETE, CALL, EXPLAIN PLAN, LOCK TABLE, MERGE etc.
The CALL and EXPLAIN PLAN statements are supported in PL/SQL only when the statements are executed dynamically.
3. Transaction Control (TCL) statements are used to manage changes made by DML statements. Changes can be made permanent, or can be revoked by the use of Transaction Control Statements.
Example:
COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION
4. Session Control Statements are used to dynamically manage user sessions.
Example:
ALTER SESSION, SET ROLE
5. System Control Statements are used to dynamically manage the database instances.
Example:
ALTER SYSTEM
6. Embedded SQL Statements are used to insert DDL, DML and TCL in some other procedural language programs.
Example:
INT part_number;
VARCHAR part_desc[40];
main()
{
EXEC SQL SELECT pdesc INTO :part_desc
FROM parts
WHERE pnum = :part_number;
}
Login to rate this answer.
