LEADER 07141nam 2200601 450 001 9910465865703321 005 20200520144314.0 010 $a1-78528-252-2 035 $a(CKB)3710000000603733 035 $a(EBL)4520790 035 $a(MiAaPQ)EBC4520790 035 $a(CaSebORM)9781785284809 035 $a(PPN)19327602X 035 $a(Au-PeEL)EBL4520790 035 $a(CaPaEBR)ebr11221850 035 $a(CaONFJC)MIL902722 035 $a(OCoLC)951665789 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 608 $aElectronic books. 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 $a9910465865703321 996 $aAdvanced Oracle PL$92170420 997 $aUNINA LEADER 01240nam a22002893i 4500 001 991003915899707536 005 20040702103452.0 008 040802s1979 it |||||||||||||||||ita 035 $ab13147213-39ule_inst 035 $aARCHE-109982$9ExL 040 $aBiblioteca Interfacoltà$bita$cA.t.i. Arché s.c.r.l. Pandora Sicilia s.r.l. 082 04$a016 110 2 $aBiblioteca comunale Augusta$0485092 245 10$aPeriodici della Biblioteca comunale Augusta di Perugia 260 $a[S.l. :$bs.n.,$c1979?] 300 $aVII, 235 p. ;$c24 cm 440 0$aQuaderni Regione dell'Umbria.$pBeni e attività culturali 500 $aSul front.: Catalogo unico regionale dei beni bibliografici 500 $aSuppl. a: Quaderni regione dell'Umbria n.17 650 4$aPeriodici$zPerugia$xBiblioteca comunale Augusta 651 4$aPerugia$xBiblioteca comunale Augusta$vCataloghi 907 $a.b13147213$b02-04-14$c05-08-04 912 $a991003915899707536 945 $aLE002 A Enc. Per. Bibl. 101$g1$i2002000433183$lle002$nC. 1$o-$pE0.00$q-$rl$s- $t0$u0$v0$w0$x0$y.i13785199$z05-08-04 996 $aPeriodici della Biblioteca comunale Augusta di Perugia$9310551 997 $aUNISALENTO 998 $ale002$b05-08-04$cm$da $e-$fita$git $h0$i1