Advanced Oracle PL/SQL Developer's Guide : (Record no. 110226)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 11275nam a22004933i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC4520790 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240729130457.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2016 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781785282522 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9781785284809 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC4520790 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL4520790 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaPaEBR)ebr11221850 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaONFJC)MIL902722 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)951665789 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D26 -- G87 2016eb |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.7565 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | K. Gupta, Saurabh. |
| 245 10 - TITLE STATEMENT | |
| Title | Advanced Oracle PL/SQL Developer's Guide : |
| Remainder of title | Master the Advanced Concepts of PL/SQL for Professional-Level Certification and Learn the New Capabilities of Oracle Database 12c. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 2nd ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Birmingham : |
| Name of producer, publisher, distributor, manufacturer | Packt Publishing, Limited, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2016. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2016. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (428 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Overview of PL/SQL Programming Concepts -- Introduction to PL/SQL -- PL/SQL program fundamentals -- Cursors - an overview -- The cursor execution cycle -- Cursor attributes -- Cursor FOR loop -- Exception handling in PL/SQL -- System-defined exceptions -- User-defined exceptions -- The RAISE_APPLICATION_ERROR procedure -- Exception propagation -- Creating stored procedures -- Executing a procedure -- Functions -- Functions - execution methods -- Restrictions on calling functions from SQL expressions -- A PL/SQL package -- Oracle Database 12c enhancements to PL/SQL subprograms -- Managing database dependencies -- Displaying the direct and indirect dependencies -- Dependency metadata -- Dependency issues and enhancements -- Reviewing Oracle-supplied packages -- Oracle SQL Developer -- Oracle SQL Developer for DBA, Developers, and Application Architects -- SQL Developer 4.0 -- Summary -- Practice exercise -- Chapter 2: Oracle 12c SQL and PL/SQL New Features -- Database consolidation and the new Multitenant architecture -- The Oracle Database 12c Multitenant architecture - features -- Multitenant for Consolidation -- Plug/unplug -- Manage Many as One -- Rapid provisioning -- CDB Resource Management -- Common users and local users -- Oracle 12c SQL and PL/SQL new features -- IDENTITY columns -- Default column value to a sequence in Oracle 12c -- The DEFAULT ON NULL clause -- Support for 32K VARCHAR2 -- Row limiting using FETCH FIRST -- Invisible columns -- Temporal databases -- In-Database Archiving -- Defining a PL/SQL subprogram in the SELECT query and PRAGMA UDF -- Test setup -- Comparative analysis -- The PL/SQL program unit white listing -- Granting roles to PL/SQL program units -- Test setup. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Miscellaneous PL/SQL enhancements -- The Oracle Database 12c (12.1.0.2) In-Memory option -- The challenge -- The problem statement and Oracle Database 12c In-Memory -- Oracle Database 12c In-Memory option features -- The Oracle Database 12c In-Memory Architecture -- Controlling the In-Memory column store -- The INMEMORY clause -- Performance optimizations -- In-Memory Advisor -- Oracle Database In-Memory benefits -- Summary -- Chapter 3: Designing PL/SQL Code -- Cursor structures -- Cursor execution cycle -- Cursor attributes -- Implicit cursors -- Explicit cursors -- Cursor variables -- Strong and weak ref cursor types -- Working with cursor variables -- SYS_REFCURSOR -- Cursor variables as arguments -- Cursor variables - restrictions -- Cursor design considerations -- Cursor design-guidelines -- Implicit statement results in Oracle Database 12c -- Subtypes -- Subtype classification -- Type compatibility with subtypes -- Summary -- Practice exercise -- Chapter 4: Using Collections -- Introduction to collections -- Collection types -- Associative arrays -- Nested tables -- Modify and drop a nested table object type -- Design considerations of a nested table -- Nested table storage -- Nested table in an index - organized table -- Nested table locators -- Nested table as the schema object -- Operations on a nested table type column -- Nested table collection type in PL/SQL -- Querying the nested table metadata -- Nested table comparison functions -- Multiset operations on nested tables -- Varray -- Varray as a schema object -- Operations on varray type columns -- Varray in PL/SQL -- Comparing the collection types -- Selecting the appropriate collection type -- Oracle 12c enhancements to collections -- PL/SQL collection methods -- EXISTS -- COUNT -- LIMIT -- FIRST and LAST -- PRIOR and NEXT -- EXTEND -- TRIM -- DELETE -- Summary -- Practice exercise. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Chapter 5: Using Advanced Interface Methods -- Overview of External Procedures -- External Procedures -- Components of external procedure execution flow -- The extproc agent -- The Library object -- Callout and Callback -- Call Specification -- How an External Procedure executes -- Environment setup -- TNSNAMES.ora -- EXTPROC.ora -- Executing external C programs from PL/SQL -- Securing External Procedures with Oracle Database 12c -- Executing Java programs from PL/SQL -- Loading a Java class into a database -- Steps to execute a Java class from an Oracle PL/SQL unit -- Summary -- Practice exercise -- Chapter 6: Virtual Private Database -- Oracle Database Security overview -- Fine-Grained Access Control -- How FGAC works -- Virtual Private Database -- How does Virtual Private Database work? -- Column-level Virtual Private Database -- Virtual Private Database with Oracle Database 12c Multitenant -- Virtual Private Database components -- Application Context -- Virtual Private Database policy function -- Policy types -- The DBMS_RLS package -- Demonstration -- Virtual Private Database features and best practices -- Virtual Private Database metadata -- Policy utilities-refresh and drop -- Oracle Database 12c Security enhancements -- Oracle Database 12c Data Redaction -- Data Redaction exemptions and miscellaneous features -- Data Redaction function types -- Demonstration -- The Data Redaction metadata -- Summary -- Practice exercise -- Chapter 7: Oracle SecureFiles -- Introduction to Large Objects -- Classification of Large Object datatypes -- Internal LOB -- External LOB -- LOB restrictions -- LOB data types in Oracle -- BLOB and CLOB -- BFILE -- Some more related stuff -- The LOB locator -- LOB instance initialization -- The DBMS_LOB package -- LOB usage notes -- Oracle SecureFiles -- Deduplication and compression -- Encryption -- File System Logging. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Write Gather Cache -- Free space management -- BasicFiles and SecureFiles -- The db_securefile parameter -- Working with LOBs -- LOB metadata -- Enabling the advanced features of a SecureFile -- Populating the LOB data -- Temporary LOB operations -- Managing temporary LOBs -- Working with a temporary LOB -- Migrating LONG to LOBs -- Use the ALTER TABLE command -- Using the TO_LOB function -- Online Table Redefinition -- Migrating BasicFiles to SecureFiles -- Oracle Database 12c enhancements to SecureFiles -- Summary -- Practice exercise -- Chapter 8: Tuning PL/SQL Code -- The PL/SQL Compiler -- Subprogram inlining in PL/SQL -- PRAGMA INLINE -- PLSQL_OPTIMIZE_LEVEL -- Native and interpreted compilation techniques -- Oracle Database 11g Real Native Compilation -- Selecting the appropriate compilation mode -- Setting the compilation mode -- Querying the compilation settings -- Compiling a program unit for native or interpreted compilation -- Recompiling a database for a PL/SQL native or interpreted compilation -- Tuning PL/SQL code -- Build secure applications using bind variables -- Call parameters by reference -- Avoiding an implicit data type conversion -- Understanding the NOT NULL constraint -- Selection of an appropriate numeric data type -- Bulk processing in PL/SQL -- BULK COLLECT -- FORALL -- Summary -- Practice exercise -- Chapter 9: Result Cache -- Oracle Database 11g Result Cache -- What is the Server Result Cache? -- Configuring the Server Result Cache -- Result Cache versus Buffer Cache -- Result Cache versus Oracle 12c Database In-Memory -- Result Cache versus In-Memory Database Cache -- SQL query Result Cache -- Monitoring the SQL Result Cache -- Invalidation of the SQL Result Cache -- Read consistency of the SQL Result Cache -- Limitations -- PL/SQL Function Result Cache -- Does it sound similar to deterministic functions?. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Differences between Result Cache and other caching techniques -- Illustration -- Monitoring the PL/SQL Result Cache -- Invalidation of the PL/SQL Result Cache -- Limitation -- OCI Client results cache -- The DBMS_RESULT_CACHE package -- Displaying the result cache memory report -- Oracle Database 12c enhancements to the PL/SQL function Result Cache -- Result cache in Real Application Clusters -- Summary -- Practice exercise -- Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code -- A sample PL/SQL program -- Tracking PL/SQL coding information -- USER_ARGUMENTS -- USER_OBJECTS -- USER_OBJECT_SIZE -- USER_SOURCE -- USER_PROCEDURES -- USER_PLSQL_OBJECT_SETTINGS and USER_STORED_SETTINGS -- USER_DEPENDENCIES -- The DBMS_DESCRIBE package -- Tracking the program execution subprogram call stack -- Tracking propagating exceptions in PL/SQL code -- Determining identifier types and usages -- USER_IDENTIFIERS -- The PL/Scope tool -- The PLSCOPE_SETTINGS parameter -- The DBMS_METADATA package -- DBMS_METADATA data types and subprograms -- Parameter requirements -- The DBMS_METADATA transformation parameters and filters -- Demonstration -- Tracing PL/SQL programs using DBMS_TRACE -- Installing the DBMS_TRACE package -- DBMS_TRACE subprograms -- Compiling a PL/SQL program for debugging -- Viewing the PL/SQL trace information -- Steps to trace PL/SQL program execution -- Profiling PL/SQL code -- The DBMS_HPROF package -- Differences between DBMS_PROFILER and DBMS_HPROF -- DBMS_HPROF subprograms -- Collecting raw profile data -- Interpreting the raw profiler data -- Analyzing profiler data -- Creating the profiler tables -- Analyzing the profiler output -- Querying the profiler tables -- The plshprof utility -- What do these reports reveal? -- Summary -- Practice exercise -- Chapter 11: Safeguarding PL/SQL Code against SQL injection -- What is SQL injection?. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SQL injection targets. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | PL/SQL (Computer program language). |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | K. Gupta, Saurabh |
| Title | Advanced Oracle PL/SQL Developer's Guide |
| Place, publisher, and date of publication | Birmingham : Packt Publishing, Limited,c2016 |
| International Standard Book Number | 9781785284809 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=4520790">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=4520790</a> |
| Public note | Click to View |
No items available.