UDEMY_PL_SQL_BY_EXAMPLE_TUTORIAL-kEISO

Section

Appz

Group

kEISO

Size

663,28 MB

Files

16

Date

2015-10-06

NFO

                                                   █▀▀▀▀
                                                   ▓ ████████ ░
                                                   ░ ████████ ▓
                                           █▀▀▀      ████████ ▀▀▀▀  ▀▀▓
                                           ▓ ███████████▓████████████ ▒
            ████████ ▄                     ░ ██████████▓▒▓███████████ ░
            ████████ █▓▄              ▄▓█▄▄  ████████▓▀ ░ ▀▀▀▓███████
 ████████▌▄ ████████ ▀▀▀▀           ▄▓███████ ░ ▄▄▄▄ ▄█▄ ▄██▄ ▓▄▄ ▄   ████████
 ▀▀▀█████▌█ ██████████████▄       ▄▓███████▀▄▄     ▓▐████████ ░       ████████
  ███████▌█ █████████████▌█▓▄   ▄▓█████████████▓▄▄ ░ ▀█████▀ ▐▄▄█████▌████████
  ███████▌ ▄████████▓████▌█▀▀▀    ▀▀████████████████▄█▄▀█▀ ▄▌░███████▌████████
███████▓▀▄████████▓▀▄████ █ ████████▄▄█▀████████████████ ▄██▌▓████████████████
▓█████▄█████████▀ ▓██████ ▀ █████▄ ▐██████▌▀▓████████▓██████▌▀██████████▀▀▀▀▀▀
  ▀▀▓████████▓▀   ████████▄ ███████▐██████▌   ▀██████▀███████ ▄▀██▓████▄ ▀██▀
  ▐▄▄ ▀▀▓███████▄▄█▀▀▓██████▄▄▐▀▓██▐███████  ▄████▓▀  ███████ ▓  ▀░██████▄▀
  ▐███░▄▄ ▐████████ ░░ ▀▀▓█████████ ███████▄██▓██▀    ▀▀█████ ░    ▀▀▓████░▄
▄▄▄▄▄█▓██ ▐████████▄▄▄▄▄▄▄ ▀▀██████ ▀▀█▀███▀▀███▄  ▄▐████████▌▄▄▄░████████▓██
▐████████ ▓███████▓██████▓  ██▄▓███████████▌██████▄▀ ████████▌███▒████▀▀▀
 ████████ ▓█████▄▄ ▄▄████▌  █████▐█████████▌████████▄████████▓███▓████  ███████
 ███▀▀▀▀▀▐███  ███ ██████████████ █████████▌ ▀██▓█████▀▀▀    ▐███████▌  ███████
  ▄▄████ ▐█      █▄▄▄▄▄▄ ▀▀▀▀▀▓██ ███▌▀▀▀ ▄▄█▄ ▀░███████▄ ▄██████████▓███████▀▀
   ▀▓▀▀▀ ▐███░ ███████▌▐▀█████▄▄▄▄▀▄▄▄██▀ ▀▓███▄ ▀███████████▌▐█▄▄▀▀▀▀▀▀▀█████
         ▓███  ███████▌██▄▀▀▀▀▓████▄▀▓██ ▓  ▀▓███▄ ▀▀████████▌▓█████████▄▄▄▄▄
         ▀▀▀▀▀▀▀▀▀▐ ██ ███          ▀▀  ▓█▓   ▀▀▀  ▄██████████     ▀▀▀▀▓███▀
          ▀▓█▀▀▀▀▀▀▀▀▀▀███       ░░ ▀▀█▓█████▀▀▄▄▓▄▄ ▀▀███████ ▓▄▄
            ▀ ████████ ▀▀▀    ▄▄▄▓▓▌  ▄██▀██▄    ▀▀▓██▄  ▀▀███ ████▓▄
           ▄▄▄████████▄▄▄▄▓▓█████▀▀  ▐▓▀ █▄▀▓█       ▀ ▄██▄▄ ▀ ▀█▀███▌
  ░▄▄▄▄██████▀██████▓██████████████  ▀ ▄████▄██▄▄▄▓██ ██████▀   ▄█████ ███▄▄▄▄▄
██▓█████▓███████████░▓█████████████ ▐████████████████░█████▌  ▄▓██▀███▌████████
▓███████░██████████████████  █▓▓▀▀▀ ▐██████▓███▌█████▓█████ ▄███▀▐████▌███████▌
░▓█████▀ ███▀▀▀█████▌▀▓█████▄   ▄▓█ ▐██████▒███████▀▀▀▐██████▓▀  ▐████▌█████▄
 ▀██████▄   ▄▓▐██████▄ ▀▓██████ █▀▀ ███████░▀███████▄ ░█████▀▄  ▄████▓███████▌
   ▀▓██████ ▀▀▐█████▓▓ ▄▄██████   ▄ ███████▄▐▄▀██████▓▓▄███▄█████████░███████▌
   ▄▄██████   ▄█████████████▌   ███▄▄███████    ▀▓███ ▄▄▄▄▄▄▄▄ ▀▀██▓▀ ███████
░███████▌   █████▐███████████  ▐████████████████   ▐█ █████████▓▄▄   ▐███████
 ▌▄▄█████  ▐█████▐█████▐██████▄█████▄███████▀███▌  ██ ▀▀░▓█████████▓▄▐███████
  ▐███████▄█████▌▐█████ ▀█████████ █▀███████▓████▄██████▓████████████████████
   ▀▓█████████▓▀▄██████ █▄▄▀▀██▓▀▀  ▓▄▀█████▀▓████████▐███████▀▓█████▀▀▀████▌
      ▀▀▓░░▀▀▄▄███████  ▀ ▄▄▄▄█████ ▄▀█▄▀███▐▄ ▀▀░░▓▀▀▐███████ ▄▄▀▀   ░▄  ▀█▌
     ▄▀ ▄ ▀▄   ████████████████▓███ ██ ▓█▄▄█ ▀██▄▄▄██▀▄▄▄▄▄▄▄▄ ██▀ ▄▀ ▄ ▀▄  ▌
    ▐▌ ■░■ ▐▌  ████████████████████ ███ ▀▓██   ▀▀▓▀▀▄██████▓▀   ▀ ▐▌ ■░■ ▐▌
     ▀▄ ■ ▄▀   ███████▓▓▀▀▀▀▀▓▓▄▄▄▄       ▀▓       ▀▀▀▀▀▀▀▀        ▀▄ ■ ▄▀
  ▄ ▀ ▐ ▓ ▌ ▀ ▄  ▄▄▄▄▄███████████▀ ▄■▀▀▀▀▀■▄                    ▄ ▀ ▐ ▓ ▌ ▀ ▄
 ■    ▐ ▒ ▌    ■  ▀████▓▓▓░░░▀▀▀ ▄▀  KYRIE  ▀▄                 ■ ▄  ▐ ▒ ▌    ■
▌   ▄▀▐ ░ ▌▀▄   ▐   ▀▀    ▄▄▄▄▄▄▄▌  ELEISON  ▐▄▄▄▄▄▄▄░        ▌  ▀▄▀▐ ░ ▌▀▄   ▐
▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄ ▄▄▓▀▀▀ ▄ ▄ ▄▀▄ ▄▄▀▀▀▄▄ ▄▀▄ ▄ ▄ ▀▀▀▓▄▄ ▄▀▀▀▄ ▀▄▓▐ ░ ▌▓▄▄ ▄▀
  ▐▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌  ▄  ▀  ▄▄▄▄▄▄█▀░   ░▀█▄▄▄▄▄▄  ▀  ▄  ▐▌ ▀▓ ▌ ▀▀▀▄▀▄▀▀▀▀▌
▄  ▀▀▀▓ ▀  ▀▀▀ ▀▄▄▄▀  ▓██ █▓▀▀     ▀▌▄   ▄▐▀     ▀▀▓█ ██▓  ▀▄▄▄▀ ▐▀▀  ▀ ▓▀▀▀  ▄
█▄   ▀▐  ▄██▄   ▄  ▄▄█▀              ▀▀▀▀▀              ▀█▄▄  ▄  ▄▄██▄  ▌▀   ▄█
▓█▓▄    █▄▀▀█▌ ▄ ▄█▓▀                                     ▀▓█▄ ▄ ▀█▀▀▄█    ▄▓█▓
 ▀▓█▓▄▄▓████▄▄▄██▀▀           RELEASE INFORMATION           ▀▀██▄ ▄████▓▄▄▓█▓▀
  ▀▓████▀▓█▀ ▀▓▀                                               ▀▓  ▀█▓▀████▓▀
 █ ▀█▓▓██▄▄██    TITLE: PL/SQL by Example                         ██▄▄██▓▓█▀ █
 █▀ ▐█▒▓██░██                                                     ██░██▓▒█▌ ▀█
 █▀  █▓███▒█▌                                                     ▐█▒███▓█  ▀█
 █▀ ▐█▓███▓█░                                                     ░█▓███▓█▌ ▀█
 █▀ ▐██████▌     PUBLISHER..........: UDEMY                        ▐██████▌ ▀█
 █▀ ▀▀████▓      LINK...............: http://v.gd/QtPewR            ▓████▀▀ ▀█
 ▌ ▓██▌▄ ▀▀      AUTHOR.............: Amarnath Reddy                ▀▀ ▄▐██▓ ▐
 ▌▐███░▒███▌     LEVEL..............: beginner level               ▐███▒░███▌▐
 ▌ ████▓████     RUNTIME............: 3 hours                      ████▓████ ▐
 █ ▐▓█▀█████░    LANGUAGE...........: ENGLISH                     ░█████▀█▓▌ █
 █▀ ▀▄█▄▄▀▀█▓    RELEASE TYPE.......: RETAIL                      ▓█▀▀▄▄█▄▀ ▀█
 █▀▄ ▄▀███▓▄     RELEASE FORMAT.....: ISO                          ▄▓███▀▄ ▄▀█
 █▀█ ▐▓▄▀████    STORE DATE:........: 2015.07.07                  ████▀▄▓▌ █▀█
 █▀█ ▐█▌▓██▓     RELEASE DATE.......: 2015.10.06                   ▓██▓▐█▌ █▀█
 ▓▀█ ▓▌░██▓      ISO SIZE...........: 695,488,512                   ▓██░▐▓ █▀▓
 ▒▀█ █ ▓█▓       ISO CHECKSUM.......: 6AB1EB0B                       ▓█▓ █ █▀▒
 ░ █ ▌░██        DISKCOUNT..........: 14 * 50MB                       ██░▐ █ ░
   ▓█▌▓█▌        SAVED MONEY........: YOU DID!                          ▐█▓▐█▓
 ░ ▒█▐██         DISKNAME...........: keiso_upe                        ██▌█▒ ░
   ░▀ ▀                                                                   ▀ ▀░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██  ▄▄▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀         TUTORIAL          ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓  ▄ █▀▀                                                   ▀▀█ ▄  ▓▄ █▀█
 █▀█ ▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄ █▀█
 █▀█ █▓ ▄▓▄▀ Learn to become a PL/SQL developer in just four       ▀▄▓▄ ▓█ █▀█
 █▀█ ▓▒  ▒  weeks.                                                   ▒  ▒▓ █▀█
 █▀█ ▒░  ░                                                           ░  ░▒ █▀█
 ▓▀█ ▒░ This fast, easy and effective course will take you              ░▒ █▀▓
 ▒▀█ ░▓  from zero PL/SQL writing skills to being able to               ▓░ █▀▒
 ░ █  ▒  write efficient programs to process data.                      ▒  █ ░
   ▓  ░                                                                 ░  ▓
 ░ ▒  ░ PL/SQL is the Oracle Procedural Language extension of SQL. A    ░  ▒ ░
   ░  PL/SQL program can have both SQL statements and procedural        ░
   ░  statements. In the PL/SQL program, the SQL statements are used    ░
   ░  to access sets of data stored in a database, while the procedural ░
   ░  statements are used to process individual piece of data and       ░
   ░  control the program flow.                                         ░
   ░                                                                    ░
   ░ In this course participants will learn                             ░
   ░                                                                    ░
   ░ * Describe the features and syntax of PL/SQL                       ░
   ░ * Design PL/SQL anonymous blocks that execute                      ░
   ░  efficiently                                                       ░
   ░ * Use the Oracle supplied PL/SQL packages to                       ░
   ░  generate screen output                                            ░
   ░ * Create and debug stored procedures and functions                 ░
   ░ * Design PL/SQL packages to group related constructs               ░
   ░ * Use PL/SQL programming constructs and conditionally control      ░
   ░  code flow                                                         ░
   ░ * Create overloaded package subprograms for more flexibility       ░
   ░ * Handle runtime errors using Exceptions                           ░
   ░ * Writing manageable code using Records                            ░
   ░ * Storing and processing data using Collections                    ░
   ░ * Processing data using Implicit and Explicit Cursors              ░
   ░                                                                    ░
   ░ Softwares used                                                     ░
   ░                                                                    ░
   ░ * Oracle Database 11g                                              ░
   ░ * SQL Developer                                                    ░
   ░                                                                    ░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██  ▄▄▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀       NOTES / NEWS        ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓  ▄ █▀▀                                                   ▀▀█ ▄  ▓▄ █▀█
 █▀█ ▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄ █▀█
 █▀█ █▓ ▄▓▄▀                                                       ▀▄▓▄ ▓█ █▀█
 █▀█ ▓▒  ▒               Huh? No news are good news!                 ▒  ▒▓ █▀█
 █▀█ ▒░  ░                                                           ░  ░▒ █▀█
 ▓▀█ ▒░                                                                 ░▒ █▀▓
 ▒▀█ ░▓                                                                 ▓░ █▀▒
 ░ █  ▒                                                                 ▒  █ ░
   ▓  ░                                                                 ░  ▓
 ░ ▒  ░                                                                 ░  ▒ ░
   ░                                                                    ░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██    ▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄░  ▀█▌▐▓▀          RESPECTS         ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄▓▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓▄ ▄▄█▀▀▀                                                  ▀▀█ ▄ ▄▓▄ █▀█
 ▌ ▐▄▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄▄▌ ▐
 ▌  ▀█▓ ▄▓▄▀       BBL - DDU - EEn - iNTENSiTY - JGT - RBS         ▀▄▓▄ ▓█▀  ▐
 ▌░   ▓  █                                                           █  ▓   ░▐
 ▌▒   ▒▄█▀                                                           ▀█▄▒   ▒▐
 ▌▓▌  ░                                                                 ░  ▐▓▐
 ▌██  ░                            SHOUTOUTS                            ░  ██▐
 ▌▐▓█                                                                     █▓▌▐
 ▌ ░▓█                                                                   █▓░ ▐
 █  ░██                                                                 ██░  █
 █▀▄ ▓██▄         DVT - FONT - iRONiSO - LAXiTY - PARADOX - SO        ▄██▓ ▄▀█
 █▀ ▄ ▓███▄                                                         ▄███▓ ▄ ▀█
 █▀  █▄▀▓█▀██▄                         ▓                         ▄██▀█▓▀▄█  ▀█
 █▀ ▀ ▀█▄▀▓█▄▀▀▓▄▄                  ▄▀ ▄ ▀▄                  ▄▄▓▀▀▄█▓▀▄█▀ ▀ ▀█
 █▀▄ ▀▄▀██▄▀▀█▄  ▀▀▓▄▄        ░  ▄▌▐▌ ■░■ ▐▌▐▄  ░        ▄▄▓▀▀  ▄█▀▀▄██▀▄▀ ▄▀█
 █▀█ ▄ ▀▄▀███▄▀▀█▄▄  ▀▀▓▄  ▄▄▄▓▓█▀  ▀▄ ■ ▄▀  ▀█▓▓▄▄▄  ▄▓▀▀  ▄▄█▀▀▄███▀▄▀ ▄ █▀█
 █▀█ █  ▀█▄▀█▄▀█▄▀▀█▄   █▓  ▀█ ▄ ▄ ▀ ▐ ▓ ▌ ▀ ▄ ▄ █▀  ▓█   ▄█▀▀▄█▀▄█▀▄█▀  █ █▀█
 █▀█ █ █  ▀█▄▀█ ▀██▄▀█▄ ▐█▓░  ▀ ■    ▐ ▒ ▌    ■ ▀  ░▓█▌ ▄█▀▄██▀ █▀▄█▀  █ █ █▀█
 █▀█ █ █ ▐▌▐██▐█▄ ▓██▐█▌██░   ░▌   ▄▀▐ ░ ▌▀▄   ▐░   ░██▐█▌██▓ ▄█▌██▌▐▌ █ █ █▀█
  ▀█ ▀████ ██▀████▐████▓▀   ▄▀▀▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄   ▀▓████▌████▀██ ████▀ █▀
   ▀█▄  ▀▀▀████▓▀▄█▓▀▀     ▐▌ ▀▓ ▌▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌     ▀▀▓█▄▀▓████▀▀▀  ▄█▀
      ▀ ▄▄    ▀▀▀▀▀▀▀   ▄▌  ▀▄▄▄▀ ▀▀▀▄ ▀ ▄▀▀▀ ▀▄▄▄▀  ▐▄   ▀████▀▀ ▄▄ ▄▄ ▀
          ▀▀█▄▄▄▄▄▄▄▄▄████▄    ▄  ██▌▐ █ ▌▐██  ▄    ▄████▄▀        ▀▄▄
                ▀▀▀▀▀▀▀▀██▓▓░░  ▄  ▀ ▐ ▓ ▌ ▀  ▄  ░░▓▓██▀▀▄ H7/BREAK ▄▀
                         ▄▀ ▄ ▀▄  ▓ ▄▐ ▒ ▌▄ ▓  ▄▀ ▄ ▀▄    ▀▐▄    ▄▌▀
                        ▐▌ ▌ ▐ ▐▌ ░  ▐ ░ ▌  ░ ▐▌ ▌ ▐ ▐▌
                         ▀▄ ▀ ▄▀▄▄   █ ░ █   ▄▄▀▄ ▀ ▄▀
                           ▀▀▀ █  █  █ ░ █  █  █ ▀▀▀
                                ▀▀  ▐▐ ░ ▌▌  ▀▀
                                    █▐ ░ ▌█
                                   ▀▄▐ ░ ▌▄▀
                                     ▐ ▒ ▌
                                     ▐ ▓ ▌
                                    ▄▀ ■ ▀▄
                                   ▐▌ ■░■ ▐▌
                                    ▀▄ ▀ ▄▀
                                      ▀░▀

Files