| contents preface acknowledgments introduction part i preparing for ocp dba exam i: sql and pl/sql 1 selecting data from oracle overview of sql and pl/sql writing basic sql statements restricting and sorting row data using single-row functions chapter summary two--minute drill fill-in-the-blank questions chapter questions fill-in-the-blank answers answers to chapter questions 2 advanced data selection in oracle displaying data from multiple tables group functions and their uses .using subqueries multiple-column subqueries producing readable output with sql*plus chapter summary two-minute drill fiil-in-the-blank questions chapter questions fill-in-the-blank answers answers to chapter questions 3 creating oracle database objects creating the tables of an oracle database including constraints the oracle data dictionary manipulating oracle data chapter summary two--minute drill fill-in-the-blank questions chapter questions fill-in-the-blank answers answers to chapter questions 4 creating other database objects in oracle creating views other database objects user access control chapter summary two-minute drill fill-in-the-blank questions chapter questions fill-in-the-blank answers answers to chapter questions 5 introducing pl/sql overview of pl/sql writing executable statements writing control structures chapter summary two-minute drill fill-in-the-blanks chapter questions fill-in-the-blank answers answers to chapter questions 6 database programming with pl/sql interacting with the oracle database working with composite datatypes explicit cursor handling understanding advanced explicit cursor concepts error handling chapter summary two-minute drill fill-in-the-blanks chapter questions fill-in-the-blank answers answers to chapter questions part ii ocp oracle8i dba practice exams 7 ocp exam i: introduction to sql and pl/sql practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to practice exam 3 index |
内容加载中，请稍后...
商品评论（0条）