This will show the different areas of SQL and Database information. Standard SQL StatementsArea
| Description
| DDL Statements
| Data Definition Language (DDL)
statements are used for managing data objects. | DML Statements
| Data Manipulation Language (DML) statements are used for managing data within schema objects. These statements do not implicitly commit the current transaction. | SQL Functions
| SQL functions are built into the database and are available for use
in various appropriate SQL statements. Do not confuse SQL functions with
user-defined functions. | Data Types
| Definition of the data types that are used within the database structures.
| Database SQL ProgrammingArea
| Description
| Concepts
|
| Structure
| | Variables
| | Constants
| | Records
| | Conditional Statements
| | Iterative Statements
| | Cursors
| | Procedures
| | Functions
| | Exception Handling
| | Triggers
| | External Coding
| | | |
* Database's are listed in alphabetical order and not by importance or market share. |