Oracle PL/SQL language : pocket reference /

Mostrar otras versiones (3)

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Feuerstein, Steven (Autor), Pribyl, Bill (Autor), Dawes, Chip (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Sebastopol, CA : O'Reilly Media, 2015.
Edición:Fifth edition.
Temas:
Oracle (Computer file)
PL/SQL (Computer program language)
Relational databases.
PL/SQL (Langage de programmation)
Bases de données relationnelles.
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Copyright; Table of Contents; Oracle PL/SQL Language Pocket Reference; Introduction; Acknowledgments; Conventions; PL/SQL Language Fundamentals; PL/SQL Character Set; Identifiers; Boolean, Numeric, and String Literals; Numeric Literals; Datetime Interval Literals; Delimiters; Comments; Pragmas; Statements; Block Structure; Variables and Program Data; Scalar Datatypes; LOB Datatypes; Implicit Datatype Conversions; NULLs in PL/SQL; Declaring Variables; Anchored Declarations; Programmer-Defined Subtypes; Conditional and Sequential Control; Conditional Control Statements
  • Sequential Control StatementsLoops; Simple Loop; Numeric FOR Loop; Cursor FOR Loop; WHILE Loop; "Repeat Until" Loop Emulation; EXIT Statement; CONTINUE Statement; Loop Labels; Database Interaction; Sequences in PL/SQL; Transaction Management; Autonomous Transactions; Cursors in PL/SQL; Explicit Cursors; Implicit Cursors; Native Dynamic SQL; DBMS_SQL; SQL Injection and Bind Variables; Cursor Variables; Cursor Expressions; Exception Handling; Declaring Exceptions; Raising Exceptions; Scope; Propagation; Records in PL/SQL; Declaring Records; Referencing a Record's Fields; Assigning Records
  • Records and DMLNested Records; Collections in PL/SQL; Declaring a Collection; Initializing a Collection; Adding and Removing Elements; Nested Table Functions; Collection Methods; Collections and Privileges; Nested Collections; Bulk Binds; Built-in Functions and Packages; Built-in Functions; Built-in Regular Expression Functions; Stored Procedures and Functions; Procedures; Functions; Parameters; Local Programs; Program Overloading; Forward Declarations; Table Functions; Function Result Cache; Privileges and Stored PL/SQL; Triggers; Creating Triggers; Trigger Predicates; DML Events
  • Compound DML TriggersDDL Events; Database Events; Packages; Package Structure; Referencing Package Elements; Package Data; SERIALLY_REUSABLE Pragma; Package Initialization; Calling PL/SQL Functions in SQL; Calling a Function; Improving Performance of Calling PL/SQL Functions from SQL; Column Name Versus Function Name Precedence; Object-Oriented Features; Object Types; Type Inheritance; Methods; Methods in Subtypes; Manipulating Objects in PL/SQL and SQL; Upcasting and Downcasting; Changing Object Types; Compilation; Compiling Stored PL/SQL Programs; Conditional Compilation; Compiler Warnings
  • Optimizing CompilerPerforming Native Compilation of PL/SQL; Java Language Integration; Example; Publishing Java to PL/SQL; Data Dictionary; Index

Ejemplares similares