Learn & Practice PL-SQL

APP CREATED FOR LEARNING PL-SQL LANGUAGE IN ORACLE DATABASE SERVER

. . . . . . . . . . . . . . . . . . . . .

This App acts as a reference for the PL-SQL language
Learn DML & DDL statements with description, syntax, notes and examples

For each statement is presented:

Detailed description of the statement/command purpose

Syntax of the statement with various options

Two examples executed from a real table (Automobile Table)


PL-SQL STATEMENTS (LEARN AND PRACTICE)
__________________________________

1. GENERAL

1.1 - Comments
1.2 - Data Types

2. (DML) Data Manipulation Language

2.1 – SELECT

- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Rownum, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union (Any & All)
- Subqueries
- Joins (Inner, Right, Left)
- Select Into

2.2 - INSERT

- With Columns names
- Without Column names
- Rules
- Insert Into ... Select

2.3 - DELETE

- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity

2.4 - UPDATE

- Update All Rows
- Update ... Where
- Rules


3. (DDL) DATA DEFINITION LANGUAGE

3.1 - CREATE

- Create Database
- Create Table
- Create Index
- Auto-Increment (Identity)
- Constraints (PK, FK, CK, DF, UQ, NN)

3.2 - ALTER

- Alter (Modify) Columns
- Add Constraints
- Drop Constrains

3.3 - DROP

- Drop Table
- Drop Database
- Drop Index

3.4 - TUNCATE

- Delete Versus Truncate