About Learn PL-SQL Programming
This App acts as a reference for the T-SQL language (SQL Server) You can learn and practice with a real database (Auto), DML & DDL statements with syntax and examples Will you start learning SQL in Oracle? Did you f
This App acts as a reference for the T-SQL language (SQL Server)
You can learn and practice with a real database (Auto), DML & DDL statements with syntax and examples
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
Jan 24, 2021
Version 1.1.1
Minor corrections
Changes to the graphical environment
Previous Versions
Here you can find the changelog of Learn PL-SQL Programming since it was posted on our website on 2021-09-06 19:17:16.
The latest version is 1.1.1 and it was updated on 2024-04-22 09:11:13. See below the changes in each version.
Learn PL-SQL Programming version 1.1.1
Updated At: 2021-01-24
Changes: Jan 24, 2021 Version 1.1.1
Minor corrections
Changes to the graphical environment
Disclaimer
Official App Store Link
We do not host Learn PL-SQL Programming on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by Apple and passed their terms and conditions to be listed there. We recommend caution when installing it.
The App Store link for Learn PL-SQL Programming is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.