01340cam--2200421---450 99000124036020331620181123145521.0000124036USA01000124036(ALEPH)000124036USA0100012403620031105d1978----km-y0itay0103----baitaIT||||||||001yy<<Il>> dolce tempomistica, ermetismo, e sogno nel CinquecentoFrancesco Gandolfoprefazione di Eugenio BattistiRomaBulzoni1978323 p.[12] c. di tav. ill.21 cmBiblioteca del Cinquecento52001Biblioteca del CinquecentoArteEsoterismoSec.16.BNCF709.31GANDOLFO,Francesco<1941- >39313BATTISTI,EugenioITsalbcISBD990001240360203316XVII A.A. 2544524 DLASXVII A.A.427645XII.2.D. 621(V C coll 95/5)81570 LMV CV D GAN1871 DBCV DBKCASDBCDLAS1020031105USA010938PATRY9020040406USA011728COPAT59020060331USA011121DBC9020071218USA011259Dolce tempo131294UNISA05585nam 2200841 a 450 991097488530332120221101212512.097866136544279781280677496128067749X97818496872321849687234(CKB)2550000000101783(EBL)946944(OCoLC)794903868(SSID)ssj0000678581(PQKBManifestationID)12257170(PQKBTitleCode)TC0000678581(PQKBWorkID)10727550(PQKB)11782956(Au-PeEL)EBL946944(CaPaEBR)ebr10563884(CaONFJC)MIL365442(PPN)228021006(OCoLC)810455880(OCoLC)ocn810455880 (FR-PaCSA)88850729(CaSebORM)9781849687225(MiAaPQ)EBC946944(FRCYB88850729)88850729(DE-B1597)723552(DE-B1597)9781849687232(EXLCZ)99255000000010178320120605d2012 uy 0engur|n|---|||||txtccrOracle advanced PL/SQL developer professional guide 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.9781849687225 1849687226 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 guidesSQL (Computer program language)XML (Document markup language)Database managementRelational databasesElectronic data processing personnelCertification004.35Gupta Saurabh K958066MiAaPQMiAaPQMiAaPQBOOK9910974885303321Oracle advanced PL4338250UNINA