LEADER 05346nam 2200745 a 450 001 9910451846703321 005 20200520144314.0 010 $a1-280-67749-X 010 $a9786613654427 010 $a1-84968-723-4 035 $a(CKB)2550000000101783 035 $a(EBL)946944 035 $a(OCoLC)794903868 035 $a(SSID)ssj0000678581 035 $a(PQKBManifestationID)12257170 035 $a(PQKBTitleCode)TC0000678581 035 $a(PQKBWorkID)10727550 035 $a(PQKB)11782956 035 $a(MiAaPQ)EBC946944 035 $a(CaSebORM)9781849687225 035 $a(PPN)228021006 035 $a(Au-PeEL)EBL946944 035 $a(CaPaEBR)ebr10563884 035 $a(CaONFJC)MIL365442 035 $a(EXLCZ)992550000000101783 100 $a20120605d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle advanced PL/SQL developer professional guide$b[electronic resource] $emaster advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination /$fSaurabh K. Gupta 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Pub.$d2012 215 $a1 online resource (440 p.) 225 0 $aEnterprise : professional expertise distilled 300 $aIncludes index. 311 $a1-84968-722-6 327 $aCover; Copyright; Credits; Foreword; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; PL/SQL-the procedural aspect; My first PL/SQL program; PL/SQL development environments; SQL Developer; SQL Developer-the history; Creating a connection; SQL Worksheet; Executing a SQL statement; Calling a SQL script from SQL Developer; Creating and executing an anonymous PL/SQL block; Debugging the PL/SQL code; Editing and saving the scripts; SQL*Plus; Executing a SQL statement in SQL*Plus 327 $aExecuting an anonymous PL/SQL blockProcedures; Executing a procedure; Functions; Function-execution methods; Restrictions on calling functions from SQL expressions; PL/SQL packages; Cursors-an overview; 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; Managing database dependencies; Displaying the direct and indirect dependencies; Dependency metadata; Dependency issues and enhancements; Reviewing Oracle-supplied packages; Summary 327 $aPractice exerciseChapter 2: Designing PL/SQL Code; Understanding cursor structures; Cursor execution cycle; Cursor design considerations; Cursor design-guidelines; Cursor attributes; Implicit cursors; Explicit cursors; Cursor variables; Ref cursor types-strong and weak; SYS_REFCURSOR; Processing a cursor variable; Cursor variables as arguments; Cursor variables-restrictions; Subtypes; Subtype classification; Oracle's predefined subtypes; User-defined subtypes; Type compatibility with subtypes; Summary; Practice exercise; Chapter 3: Using Collections; Collections-an overview; Categorization 327 $aSelecting an appropriate collection typeAssociative arrays; Nested tables; Nested table collection type as the database object; DML operations on nested table columns; A nested table collection type in PL/SQL; Additional features of a nested table; Varray; Varray in PL/SQL; Varray as a database collection type; DML operations on varray type columns; Collections-a comparative study; Common characteristics of collection types; Nested table versus associative arrays; Nested table versus varrays; PL/SQL collection methods; EXISTS; COUNT; LIMIT; FIRST and LAST; PRIOR and NEXT; EXTEND; TRIM; DELETE 327 $aManipulating collection elementsCollection initialization; Summary; Practice exercise; Chapter 4: Using Advanced Interface Methods; Understanding external routines; Architecture of external routines; Oracle Net Configuration; TNSNAMES.ora; LISTENER.ora; Oracle Net Configuration verification; Benefits of external procedures; Executing external C programs from PL/SQL; Executing C program through external procedure-development steps; Executing Java programs from PL/SQL; Calling a Java class method from PL/SQL; Uploading a Java class into the database-development steps 327 $aThe loadjava utility-an illustration 330 $aMaster advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination 606 $aSQL (Computer program language) 606 $aXML (Document markup language) 606 $aDatabase management$vHandbooks, manuals, etc 606 $aRelational databases$vHandbooks, manuals, etc 606 $aElectronic data processing personnel$xCertification$vStudy guides 608 $aElectronic books. 615 0$aSQL (Computer program language) 615 0$aXML (Document markup language) 615 0$aDatabase management 615 0$aRelational databases 615 0$aElectronic data processing personnel$xCertification 676 $a004.35 700 $aGupta$b Saurabh K$0958066 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910451846703321 996 $aOracle advanced PL$92253384 997 $aUNINA