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 / / Saurabh K. Gupta |
Autore | Gupta Saurabh K. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , 2016 |
Descrizione fisica | 1 online resource (428 p.) |
Disciplina | 005.7565 |
Collana | Professional expertise distilled |
Soggetto topico |
PL/SQL (Computer program language)
Database design |
Soggetto genere / forma | Electronic books. |
ISBN | 1-78528-252-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 PL/SQL program fundamentals |
Record Nr. | UNINA-9910465865703321 |
Gupta Saurabh K. | ||
Birmingham : , : Packt Publishing, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
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 / / Saurabh K. Gupta |
Autore | Gupta Saurabh K. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , 2016 |
Descrizione fisica | 1 online resource (428 p.) |
Disciplina | 005.7565 |
Collana | Professional expertise distilled |
Soggetto topico |
PL/SQL (Computer program language)
Database design |
ISBN | 1-78528-252-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 PL/SQL program fundamentals |
Record Nr. | UNINA-9910798172003321 |
Gupta Saurabh K. | ||
Birmingham : , : Packt Publishing, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
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 / / Saurabh K. Gupta |
Autore | Gupta Saurabh K. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , 2016 |
Descrizione fisica | 1 online resource (428 p.) |
Disciplina | 005.7565 |
Collana | Professional expertise distilled |
Soggetto topico |
PL/SQL (Computer program language)
Database design |
ISBN | 1-78528-252-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 PL/SQL program fundamentals |
Record Nr. | UNINA-9910815849803321 |
Gupta Saurabh K. | ||
Birmingham : , : Packt Publishing, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|