Top Apps

Search for any app

Learn & Practice PL-SQL

Publisher: Paulo Narra
Price: 1.99 USD
Compatibility: iPhone

App Rank History

Check out the download rank history for Learn & Practice PL-SQL in United States.

Rank History shows how popular Learn & Practice PL-SQL is in the iOS, and how that’s changed over time. You can track the performance of Learn & Practice PL-SQL every hour of every day across different countries, categories and devices.

Discover More After Free Registration!

App Store Optimization

Track top keywords for every app out there, as well as how an app’s search position is trending over time for the keywords that matter.

App Reviews and Ratings

Get important user feedback by exploring App Reviews and Ratings. Slice and dice by version, country, and date range, to discover bugs, track suggestions and improve your app.

Featured

Find out when and where apps have been featured in the different app stores for any day, country, device and section.

App Description

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

App Store Optimization

What words do people use when trying to find an app? The right keywords can help an app to get discovered more often, and increase downloads and revenue. App Annie tracks millions of keywords so you can get more downloads for your app, and understand what keywords your competitors are using.

App Reviews and Ratings

Find out what users think of Learn & Practice PL-SQL by reading the reviews and checking the rating.

0

0 ratings

Learn everything about millions of apps and what’s happening in the app industry with App Annie.