正在更新

iPhone 屏幕截图

截屏
截屏
截屏
截屏
截屏
截屏
截屏
截屏
截屏
截屏

简介

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

卖方

信息

开发商

类别

版本

1.0

大小

3.1 MB

Game Center

VPP Device Licensing

评分

评级:4+

兼容性

iOS 13.0 或更高

设备

iPhone 5s, iPhone 6, iPhone 6 Plus, iPhone 6s, iPhone 6s Plus, iPhone SE, iPhone 7, iPhone 7 Plus, iPhone 8, iPhone 8 Plus, iPhone X, iPhone XR, iPhone XS, iPhone XS Max, iPhone 11, iPhone 11 Pro, iPhone 11 Pro Max, iPhone SE(第 2 代), iPhone 12, iPhone 12 Pro, iPhone 12 Pro Max, iPhone 12 mini, iPad(第 5 代)WLAN, iPad(第 5 代)WLAN + Cellular, iPad(第 6 代)WLAN, iPad(第 6 代)WLAN + Cellular, iPad Pro, iPad Pro (Cellular), iPad Pro(9.7 英寸), iPad Pro(9.7 英寸) (Cellular), iPad Pro(12.9 英寸,第 2 代), iPad Pro(12.9 英寸,第 2 代) WLAN + Cellular, iPad Pro(10.5 英寸), iPad Pro(10.5 英寸) WLAN + Cellular, iPad Pro(11 英寸), iPad Pro(11 英寸) WLAN + Cellular, iPad Pro(12.9 英寸,第 3 代), iPad Pro(12.9 英寸,第 3 代) Wi-Fi + Cellular, iPad Air, iPad Air (Cellular), iPad Air 2, iPad Air 2 (Cellular), iPad Air(第三代), iPad Air(第三代) WLAN + Cellular, iPad mini Retina, iPad mini Retina (Cellular), iPad mini 3, iPad mini 3 (Cellular), iPad mini 4, iPad mini 4 (Cellular), iPad mini(第 5 代), iPad mini(第 5 代)WLAN + Cellular, iPad(第 7 代)WLAN, 11 英寸 iPad Pro(第 2 代), 11 英寸 iPad Pro(第 2 代) 无线局域网, 12.9 英寸 iPad Pro(第 4 代), 12.9 英寸 iPad Pro(第 4 代) 无线局域网, iPad Air(第 4 代)(Wi-Fi), iPad Air(第 4 代)(WLAN + Cellular), iPad(第 8 代)WLAN, iPad(第 8 代)WLAN + Cellular, iPod touch(第六代), iPod touch(第 7 代)

语言

英文

App Store:用户评分

所有版本

 0.0 (无平价)

App Store:买家评论

无条目