We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our terms and conditions for more information.

Next up

Copy and Edit

PL/SQL

Description

Mind Map on PL/SQL, created by Yuri Felipe on 20/02/2017.

Mind Map by Yuri Felipe, updated more than 1 year ago More Less

	Created by lud.ska over 10 years ago

	Copied by Yuri Felipe over 7 years ago

Resource summary

PL/SQL

Engine
1. SQL Query
  1. Oracle Process
Advantages
1. Block Structure
2. Error handling
3. Performance
  Annotations:
  - PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
Stored
1. Client
2. Database
Block
1. Anonymous
2. Named
  1. Procedures
  2. Functions
3. Structure
  1. Declaration Section
    1. Variables
      1. Scope
      2. Types
        Scalar
        Number
        Character
        DateTime
        Composite
        Reference
  2. Execution Section
    1. Conditions Statements
    2. Iterative Statements
    3. Cursors
      1. Implicit
      2. Explicit
  3. Exception Section

Show full summary Hide full summary

Want to create your own Mind Maps for free with GoConqr? Learn more.

Similar

Capítulo 2 - SQL Fundamentals I

waldir oliveira

PL/SQL

Luiz Prado

fluxo do sistema MV - PLSQL

Alex José Silva

Conceitos

Gustavo Mendes

SQL Comands

Marcelo Braga2690

Banco de dados e SGBD

bruno de assis

SQL - Introdução à linguagem.

Henrique Greg

Oracle Cloud Infrastructure Foundations 2021 Associate exam questions

Simone Stefani

Oracle Certified Java Associate 7

Rafael Mulock

BANCO DE DADOS

bruno de assis

CET_TARDE - MTA Database - E_COMANDS

Hawerth Castro

Browse Library