Sql Statements

a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects.

b) Data Manipulation Language(DML) :: The DML statments manipulate database data.

c) Transaction Control Statements :: Manage change by DML

d) Session Control :: Used to control the properties of current session enabling and disabling roles and changing .e.g :: Alter Statements,Set Role

e) System Control Statements :: Change Properties of Oracle Instance .e.g:: Alter System

f) Embedded Sql :: Incorporate DDL,DML and T.C.S in Programming

Advertisements

One thought on “Sql Statements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s