LEADER 01127nam0-2200313---450- 001 990009177020403321 005 20100505161805.0 010 $a88-85022-21-9 035 $a000917702 035 $aFED01000917702 035 $a(Aleph)000917702FED01 035 $a000917702 100 $a20100423d1985----km-y0itay50------ba 101 0 $amul 102 $aIT 105 $aa-------101yy 200 1 $aVino$eatti del 2. Simposio internazionale sul vino$ebevanda ed alimento dell'uomo moderno$e5-7 giugno 1984, Pavia (Italia)$f[a cura di] Istituto di enologia Università cattolica del Sacro Cuore Piacenza, Camera di commercio industria artigianato agricoltura Pavia 210 $aPinerolo$cChiriotti$dstampa 1985 610 0 $aVino 710 12$aSimposio internazionale sul vino$d2.$f<1985 ;$ePavia>$0507580 712 02$aUniversità cattolica del Sacro Cuore 712 02$aCamera di commercio, industria, artigianato e agricoltura di Pavia 801 0$aIT$bUNINA$gRICA$2UNIMARC 901 $aBK 912 $a990009177020403321 952 $aIG 14 F 09$fDMIGI 959 $aDMIGI 996 $aVino$9779373 997 $aUNINA LEADER 05585nam 2200841 a 450 001 9910974885303321 005 20221101212512.0 010 $a9786613654427 010 $a9781280677496 010 $a128067749X 010 $a9781849687232 010 $a1849687234 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(Au-PeEL)EBL946944 035 $a(CaPaEBR)ebr10563884 035 $a(CaONFJC)MIL365442 035 $a(PPN)228021006 035 $a(OCoLC)810455880 035 $a(OCoLC)ocn810455880 035 $a(FR-PaCSA)88850729 035 $a(CaSebORM)9781849687225 035 $a(MiAaPQ)EBC946944 035 $a(FRCYB88850729)88850729 035 $a(DE-B1597)723552 035 $a(DE-B1597)9781849687232 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 $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 08$a9781849687225 311 08$a1849687226 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 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 $a9910974885303321 996 $aOracle advanced PL$94338250 997 $aUNINA