What are the types of SQL statement

Showing Answers 1 - 7 of 7 Answers

Anurooba Balakrishnan

  • Jun 27th, 2005
 

Data Manipulation Language 
Data Definiton language 
transaction control 
session control 
system control

  Was this answer useful?  Yes

sasidhar

  • Aug 4th, 2005
 

The types of sql statements are DML,DDL,DCL,TCL

  Was this answer useful?  Yes

Jagdish

  • Aug 22nd, 2005
 

There are 3 types of sql stm. 
ddl, dml, dtl 

  Was this answer useful?  Yes

Indu

  • Sep 15th, 2005
 

select - data retrieval

insert, update, delete, merge - DML

Create, alter, drop, rename, truncate - DDL

Commit, rollback, savepoint - transaction control

grant, revoke - DCL

annathurai

  • 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

  Was this answer useful?  Yes

Narayana

  • Apr 21st, 2006
 

DDL - create, drop, etc.,

DML - Select, Insert, Update, Delete, etc.,

DCL - Grant, Revoke, etc.,

TCL -Savepoint, commit, Rollback, etc.,

  Was this answer useful?  Yes

kshsingh1

  • Jan 21st, 2007
 

There are Basically 5 types of SQL Statement

Data Manipulation Statements

Data Definition Statements

Transaction Control Statements

Session Control Statements

System Control Statements

  Was this answer useful?  Yes

sandhya

  • Sep 12th, 2007
 

Data Definition Language: Create, Alter
Data Modification Language: Update,insert, Delete, Truncate
Data Control Language: Commit, Rollback

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

csbhaskar

  • Mar 25th, 2011
 

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;
                  
}

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions