Tuesday 11 October 2011

Types of SQL Statements

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\li1080\lang1033\f0\fs22 There are basically 6 types of sql statements. They are\par
\par
a) Data Definition Language (DDL): The DDL statements define and maintain objects and drop objects.\par
b) Data Manipulation Language (DML): The DML statements manipulate database data.\par
c) Transaction Control Statements: Manage change by DML\par
d) Session Control: Used to control the properties of current session enabling and disabling roles and changing .e.g: Alter Statements, Set Role\par
e) System Control Statements: Change Properties of Oracle Instance. e.g.: Alter System\par
\par
\pard\sa200\sl276\slmult1 f) Embedded Sql: Incorporate DDL, DML and T.C.S in Programming Language.e.g: Using the Sql Statements in languages such as 'C', Open, Fetch, execute and close\lang9\f1\par
}

No comments:

Post a Comment