Saiko Consulting's SqlChallenge

Home
Why It Works How It Works
Daily Challenge
Challenge Winners Contact

Companies

Recruiter Tools

Post SqlAds

Resume Razor

Candidates

Training

Intro to

Informatica

Top 10

grabowski

vlg

anjugarg

billw

jjahns

drj

nisha

nishardhini

grifman

kalaabhyas

Yesterdays Results
86% Correct
14% Incorrect

Sponsored Jobs

IT Analyst (business analyst)

Bristol, CT

documentation, user interaction re: full sdlc responsibility. Security access, full sdlc, post-requirement. more...

DataStage Developer

Iowa, IA

DataStage, Informatica, Oracle, Team Leader more...

Production Support Analyst - Unix, FTP

Bristol, CT

Momentum, Odin, ConnectDirect, Tidal, BARR, and Tandem application and O/S software more...

DB2 DBA

New Haven Area, CT

DB2, DBA, Logical & Physical Modeling more...

Project Manager (Multiple)

Windsor, CT

Junior to Senior Level Project Managers with Insurance Background more...

Data Modeler

Shelton, CT

UML, Rational, RequisitePro more...

Business Analyst

Windsor, CT

Insurance B/A more...

Read A Topic

Return To Topics	Originally Posted: 6/6/2006 5:47:04 PM
	Last Updated: 6/6/2006 5:47:04 PM

Subject:

DML, DQL, DCL, DDL???

You Asked....

I don't think there is such a thing as DQL, simply DML covers queries and updates, DDL structure.

and we responded....

DML - Data Manipulation Language (i.e. INSERT, UPDATE, DELETE)

DQL - Data Query Language (i.e. SELECT)

DDL - Data Definition Language (i.e. CREATE TABLE, ALTER TABLE)

DCL was from my old System36 days when I was a computer operator it stood for at the time Data Command Language. If there are any Sys36 people out there please correct if I used the DCL acronym incorrectly.

Here is an good article that you may want to reference:

http://www.ilook.fsnet.co.uk/ora_sql/sqlmain.htm

others said....

Post Your Own Review