Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c /

Mostrar otras versiones (1)

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Gupta, Saurabh K. (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Burmingham, UK : Packt Publishing, 2016.
Edición:Second edition.
Colección:Professional experience distilled.
Temas:
Oracle (Computer file)
PL/SQL (Computer program language)
Java (Computer program language)
Database design.
Database management.
PL/SQL (Langage de programmation)
Java (Langage de programmation)
Bases de données > Conception.
Bases de données > Gestion.
COMPUTERS / Databases / General.
COMPUTERS / Programming Languages / Java.
COMPUTERS / Programming Languages / SQL.
Database design
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection
  • Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors
  • an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables
  • Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview
  • Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache
  • OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary

Ejemplares similares