lud.ska
Mind Map by , created over 5 years ago

PL/SQL Mind Map on PL/SQL, created by lud.ska on 06/19/2014.

67
1
0
Tags
lud.ska
Created by lud.ska over 5 years ago
fluxo do sistema MV - PLSQL
Alex José Silva
Oracle Certified Java Associate 7
Rafael Mulock
Conceitos
Gustavo Mendes
Definitions in AS chemistry
Stephen Cole
ORGANIZACIÓN DE LAS NACIONES UNIDAS
Deysi Cuautle
Banco de dados e SGBD
bruno de assis
SQL Comands
Marcelo Braga2690
SQL - Introdução à linguagem.
Henrique Greg
Modelagem de Banco de Dados
Júnio Rocha
Capítulo 2 - SQL Fundamentals I
waldir oliveira
PL/SQL
1 Engine
1.1 SQL Query
1.1.1 Oracle Process
2 Advantages
2.1 Block Structure
2.2 Error handling
2.3 Performance

Annotations:

  • PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
3 Stored
3.1 Client
3.2 Database
4 Block
4.1 Anonymous
4.2 Named
4.2.1 Procedures
4.2.2 Functions
4.3 Structure
4.3.1 Declaration Section
4.3.1.1 Variables
4.3.1.1.1 Scope
4.3.1.1.2 Types
4.3.1.1.2.1 Scalar
4.3.1.1.2.1.1 Number
4.3.1.1.2.1.2 Character
4.3.1.1.2.1.3 DateTime
4.3.1.1.2.2 Composite
4.3.1.1.2.3 Reference
4.3.2 Execution Section
4.3.2.1 Conditions Statements
4.3.2.2 Iterative Statements
4.3.2.3 Cursors
4.3.2.3.1 Implicit
4.3.2.3.2 Explicit
4.3.3 Exception Section

Media attachments