- SQL is used to Operate all relational data model Produts
- In 19770 E.F.Codd Introduced Relational Data Model
- And Also Introduced a new Language In Data Base side
- The Language is DSL/ALPHA Language. It a Non-Procedure Language
- In IBM System/R Team developed simplefication of the DSL ALPH Laguage colled SUQRE
- Again IBM Modifies SQURE Language and introduced a new Language SEQUEL Language
- Again Modified the SEQUEL and Introduced One more new language is SQL
- ANSI (American Standard Institute Provide ) provide the SQL is the Standard Language for all Relational Data Base
- So SQL language also called as ANSI SQL
- Based Ansi SQL standard Oracle Created Oracle SQL, Microsoft Created Sql Sever, IBM Createf DB2 etc.
Oracle SQL Language having the Following Sub Languages
- Data Query Language(DQL)
- Data Definition Language(DDL)
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Transaction Control Language(TCL)
- System Control Language(SYSL)
- Session Control Language(SCL)
Top Questions on Above Class:
- Which Sub Languages are using in DBA's?
- Why Sub Languages in SQL
- What is the different Between DDL and DML?
- What is DDL?
- What is DML?
- What is DCL?
- What is TCL?
- What is SCL?
- What is DQL?
No comments:
Post a Comment