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

Project Manager (Multiple)

Windsor, CT

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

IT Analyst (business analyst)

Bristol, CT

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

Business Analyst

Windsor, CT

Insurance B/A more...

DataStage Developer

Iowa, IA

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

Database Programming Specialist

Atlanta, GA

Advanced SQL query experience; - Five years of experience in software development; - Experience in building web-based programming applications with relational databases in a multi-tier environment more...

Data Modeler

Shelton, CT

UML, Rational, RequisitePro more...

Production Support Analyst - Unix, FTP

Bristol, CT

Momentum, Odin, ConnectDirect, Tidal, BARR, and Tandem application and O/S software 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