Copy and Edit

PL/SQL

Description

Mind Map on PL/SQL, created by Yuri Felipe on 20/02/2017.
Yuri Felipe
Mind Map by Yuri Felipe, updated more than 1 year ago More Less
lud.ska
Created by lud.ska over 10 years ago
Yuri Felipe
Copied by Yuri Felipe almost 8 years ago
3
0
0

Resource summary

PL/SQL
  1. Engine
    1. SQL Query
      1. Oracle Process
    2. Advantages
      1. Block Structure
        1. Error handling
          1. Performance

            Annotations:

            • PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
          2. Stored
            1. Client
              1. Database
              2. Block
                1. Anonymous
                  1. Named
                    1. Procedures
                      1. Functions
                      2. Structure
                        1. Declaration Section
                          1. Variables
                            1. Scope
                              1. Types
                                1. Scalar
                                  1. Number
                                    1. Character
                                      1. DateTime
                                      2. Composite
                                        1. Reference
                                    2. Execution Section
                                      1. Conditions Statements
                                        1. Iterative Statements
                                          1. Cursors
                                            1. Implicit
                                              1. Explicit
                                            2. 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