05346nam 2200745 a 450 991045184670332120200520144314.01-280-67749-X97866136544271-84968-723-4(CKB)2550000000101783(EBL)946944(OCoLC)794903868(SSID)ssj0000678581(PQKBManifestationID)12257170(PQKBTitleCode)TC0000678581(PQKBWorkID)10727550(PQKB)11782956(MiAaPQ)EBC946944(CaSebORM)9781849687225(PPN)228021006(Au-PeEL)EBL946944(CaPaEBR)ebr10563884(CaONFJC)MIL365442(EXLCZ)99255000000010178320120605d2012 uy 0engur|n|---|||||txtccrOracle advanced PL/SQL developer professional guide[electronic resource] master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination /Saurabh K. Gupta1st editionBirmingham, U.K. Packt Pub.20121 online resource (440 p.)Enterprise : professional expertise distilledIncludes index.1-84968-722-6 Cover; 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*PlusExecuting 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; SummaryPractice 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; CategorizationSelecting 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; DELETEManipulating 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 stepsThe loadjava utility-an illustrationMaster advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examinationSQL (Computer program language)XML (Document markup language)Database managementHandbooks, manuals, etcRelational databasesHandbooks, manuals, etcElectronic data processing personnelCertificationStudy guidesElectronic books.SQL (Computer program language)XML (Document markup language)Database managementRelational databasesElectronic data processing personnelCertification004.35Gupta Saurabh K958066MiAaPQMiAaPQMiAaPQBOOK9910451846703321Oracle advanced PL2253384UNINA