{"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":25,"n_cols":5,"rows_kept":25,"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],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[14,2,14,3],[15,2,15,3],[18,2,18,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910778843903321"]
[null,null,"Autore",null,"Dawes Chip"]
[null,null,"Titolo",null,"OCA/OCP [[electronic resource] ] : introduction to Oracle9i SQL : study guide / / Chip Dawes, Biju Thomas"]
[null,null,"Pubbl/distr/stampa",null,"San Francisco, CA, : Sybex, 2002"]
[null,null,"ISBN",null,"1-280-65252-7"]
[{"$nulls":4},"9786610652525"]
[{"$nulls":4},"0-585-47721-3"]
[{"$nulls":4},"0-7821-5250-3"]
[null,null,"Edizione",null,"[1st ed.]"]
[null,null,"Descrizione fisica",null,"1 online resource (611 p.)"]
[null,null,"Disciplina",null,"005.75/85"]
[null,null,"Soggetti",null,"Electronic data processing personnel - Certification"]
[{"$nulls":4},"Database management - Examinations"]
[{"$nulls":4},"SQL (Computer program language)"]
[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","\"Exam 1Z0-007\"--Cover."]
[null,null,"Nota di contenuto",null,"OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output"]
[{"$nulls":4},"Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals"]
[{"$nulls":4},"Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: "]
[{"$nulls":4},"Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions"]
[{"$nulls":4},"Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences"]
[{"$nulls":4},"Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index"]
[null,null,null,"Sommario/riassunto","Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9i environment* Hundreds of challenging review questions, in the book and on the CDAuthoritative coverage of all exam objectives, including:* Writing basic SQL SELECT statements* Restricting and sorting data* Displaying data from multiple tables* Aggregating data using group functions* Producing readable output with iSQL*Plus* Creating and managing tables* Controlling"]