# Learn PL-SQL Programming — Learn DML and DDL statements

> Learn DML and DDL statements (iPhone/iPad app by Paulo Narra.)

- Source: https://appshunter.io/ios/app/learn-pl/id1528940695 (this page in markdown: same URL + `.md`)
- Developer: [Paulo Narra](https://appshunter.io/developer/1251717382)
- Category: Developer Tools, Education
- Price: $1.99
- Age rating: 4+
- Requires: iOS 13.0 · 3 MB
- Languages: American English
- Released: 2020-08-27
- Data updated: 2025-01-09
- User reviews in markdown: https://appshunter.io/ios/app/learn-pl/id1528940695/reviews.md

## What is Learn PL?

Will you start learning SQL in Oracle?
Did you forget the statements many times?
Do you no longer remember the syntax and the result of an statement?

Developed to easily learn SQL Programming (T-SQL) for Oracle

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

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)

Provides:
. . . . . . . . . . . . . . . . . . . . . 

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


## Version history (last 3 releases)

### 1.1.1 — 2021-01-24

Minor corrections
Changes to the graphical environment

### 1.1 — 2021-01-21

Minor corrections
Changes to the graphical environment

### 1.0 — 2020-08-27

No release notes.

## Apps similar to Learn PL

| App | Rating | Price | Category |
| --- | --- | --- | --- |
| [DC Suite](https://appshunter.io/ios/app/dc-suite/id1587071898) | 1.0 (1) | Free | Developer Tools |
| [Docker Server Admin](https://appshunter.io/ios/app/docker-server-admin/id1591150334) | 4.7 (136) | Free | Developer Tools |
| [Sprite Cutter+](https://appshunter.io/ios/app/sprite-cutter/id1562779425) | — | $0.99 | Developer Tools |
| [php - programming language](https://appshunter.io/ios/app/php/id841823903) | 4.9 (41) | Free | Developer Tools |
| [PPHub For GitHub - Developer](https://appshunter.io/ios/app/pphub-for-github/id1314212521) | 4.9 (78) | $0.99 | Developer Tools |
| [Python3IDE](https://appshunter.io/ios/app/python3ide/id1357215444) | 3.7 (6) | Free | Developer Tools |

## More apps by Paulo Narra

- [First Degree Equation (ax+b=c)](https://appshunter.io/ios/app/first-degree-equation-axbc/id1344600536)
- [Naturally Detox](https://appshunter.io/ios/app/naturally-detox/id1449044679)
- [Pixel ColorPicker](https://appshunter.io/ios/app/pixel-colorpicker/id1461719530)
- [Learn & Validate SQL](https://appshunter.io/ios/app/learn-and-validate-sql/id1491822242)
- [Learn SQL for MySQL](https://appshunter.io/ios/app/learn-sql-for-mysql/id1521671915)
- [Learn Ps Tools](https://appshunter.io/ios/app/learn-ps-tools/id1525100016)

All apps by Paulo Narra: https://appshunter.io/developer/1251717382

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2025-01-09.*