Saturday, March 1, 2014

What is SQL and its Satements?


SQL:-
    SQL means Structured Query Language.Sql is programming language.
    SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper,"A Relational Model of Data for Large Shared Data Banks."
    SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
  
  
SQL Statement-

DRL(Data Retrieval Language):- Retrieve data from database. SELECT is a DRL statement.

DDL(Data Definition Language):- Its work on Data Structure. It is an auto committed Command. CREATE, DROP, TRUNCATE, ALTER and RENAME are DDL Statement.

DML(Data Manipulation Language):- Its work on Data in database. INSERT, UPDATE, DELETE and MERGE are DML Statement.

DCL(Data Control Language):- In DCL, developer give or remove access right to Oracle database objects. GRANT and REVOKE are the DCL statement.

TCL(Transaction Control Language):- In TCL, manage the changes made by DML statement. COMMIT, ROLLBACK and SAVEPOINT are TCL statement.


No comments:

Post a Comment