{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["report2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"report2","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[18,2,18,3],[19,2,19,3],[22,2,22,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910974885303321"]
[null,null,"Autore",null,"Gupta Saurabh K"]
[null,null,"Titolo",null,"Oracle advanced PL/SQL developer professional guide : master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination / / Saurabh K. Gupta"]
[null,null,"Pubbl/distr/stampa",null,"Birmingham, U.K., : Packt Pub., 2012"]
[null,null,"ISBN",null,"9786613654427"]
[{"$nulls":4},"9781280677496"]
[{"$nulls":4},"128067749X"]
[{"$nulls":4},"9781849687232"]
[{"$nulls":4},"1849687234"]
[null,null,"Edizione",null,"[1st edition]"]
[null,null,"Descrizione fisica",null,"1 online resource (440 p.)"]
[null,null,"Collana",null,"Enterprise : professional expertise distilled"]
[null,null,"Disciplina",null,"004.35"]
[null,null,"Soggetti",null,"SQL (Computer program language)"]
[{"$nulls":4},"XML (Document markup language)"]
[{"$nulls":4},"Database management"]
[{"$nulls":4},"Relational databases"]
[{"$nulls":4},"Electronic data processing personnel - Certification"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","Includes index."]
[null,null,"Nota di contenuto",null,"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*Plus"]
[{"$nulls":4},"Executing 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 "]
[{"$nulls":4},"the direct and indirect dependencies; Dependency metadata; Dependency issues and enhancements; Reviewing Oracle-supplied packages; Summary"]
[{"$nulls":4},"Practice 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"]
[{"$nulls":4},"Selecting 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"]
[{"$nulls":4},"Manipulating 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"]
[{"$nulls":4},"The loadjava utility-an illustration"]
[null,null,null,"Sommario/riassunto","Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination"]