SQL Hints and Tips

This section looks at the fundamental basics of the Structured Query Language, SQL (pronounced “ess-que-el” or “sequel”) within Oracle.  This is the language that is used to communicate with almost all database products on the market – the standard language for any database system according to ANSI (American National Standards Institute).

SQL can be split into 2 main groups Data Definition Language (DDL) and Data Manipulation Language (DML).

DDL
  • Data Definition Language (DDL) is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users...
DML
  • DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database...

Leave a Reply

Your email address will not be published. Required fields are marked *