LEADER 07107nam 2200589 450 001 9910798172003321 005 20200520144314.0 010 $a1-78528-252-2 035 $a(CKB)3710000000603733 035 $a(EBL)4520790 035 $a(Au-PeEL)EBL4520790 035 $a(CaPaEBR)ebr11221850 035 $a(CaONFJC)MIL902722 035 $a(OCoLC)951665789 035 $a(CaSebORM)9781785284809 035 $a(MiAaPQ)EBC4520790 035 $a(PPN)220206201 035 $a(EXLCZ)993710000000603733 100 $a20160707d2016 uy| 0 101 0 $aeng 135 $aur|n|---||||| 181 $2rdacontent 182 $2rdamedia 183 $2rdacarrier 200 10$aAdvanced Oracle PL/SQL developer's guide $emaster the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c /$fSaurabh K. Gupta 205 $aSecond edition. 210 1$aBirmingham :$cPackt Publishing,$d2016. 215 $a1 online resource (428 p.) 225 1 $aProfessional expertise distilled 300 $aIncludes index. 311 $a1-78528-480-0 327 $aCover; 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 327 $aChapter 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 327 $aImplicit 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 327 $aFine-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 327 $aOCI 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 327 $aPL/SQL program fundamentals 330 $aMaster the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination Build robust and secure applications in Oracle PL/SQL using the best practices Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn Learn and understand the key SQL and PL/SQL features of Oracle Database 12c Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling Implement Virtual Private Databases to prevent unauthorized data access Trace, analyze, profile, and debug PL/SQL code while developing database applications Integrate the new application development features of Oracle Database 12c with the current concepts Discover techniques to analyze and maintain PL/SQL code Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions,... 410 0$aProfessional expertise distilled. 606 $aPL/SQL (Computer program language) 606 $aDatabase design 615 0$aPL/SQL (Computer program language) 615 0$aDatabase design. 676 $a005.7565 700 $aGupta$b Saurabh K.$0958066 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910798172003321 996 $aAdvanced Oracle PL$93854950 997 $aUNINA LEADER 00948nas 2200301-a 450 001 9910388765403321 005 20240413013805.0 011 $a1664-9885 035 $a(CKB)1000000000316706 035 $a(CONSER)sn-95058026- 035 $a(EXLCZ)991000000000316706 100 $a19950125a18799999 k-- - 101 0 $afre 200 03$aLa tribune de Genève 210 $aGenève [Geneva, Switzerland] $cLa Tribune de Genève 215 $a1 online resource 300 $aPublished in various chronological eds. 311 $aPrint version: La tribune de Genève. (DLC)sn-95058026- (OCoLC)31882232 1010-2248 531 $aLA TRIBUNE DE GEN?VE 531 1 $aTrib. Genève 607 $aGeneva (Switzerland)$vNewspapers 607 $aSwitzerland$zGeneva$2fast 608 $aNewspapers.$2fast 906 $aJOURNAL 912 $a9910388765403321 920 $aexl_impl conversion 996 $aLa tribune de Genève$92156997 997 $aUNINA