Cargando…
Oracle advanced PL/SQL developer professional guide : master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination /
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub.,
2012.
|
| Colección: | Enterprise : professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn797834406 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 120605s2012 enka of 001 0 eng d | ||
| 040 | |a E7B |b eng |e pn |c E7B |d OCLCO |d UMI |d OCLCQ |d COO |d DEBSZ |d OCLCO |d OCLCQ |d OCLCO |d OCLCF |d OCLCO |d OCLCQ |d OCLCO |d AZK |d LOA |d AGLDB |d MOR |d PIFAG |d OCLCQ |d U3W |d STF |d WRM |d OCLCQ |d CEF |d NRAMU |d INT |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d A6Q |d HS0 |d UKCRE |d BOL |d OCLCO |d OCLCQ | ||
| 019 | |a 810455880 |a 961490116 |a 962626187 |a 974762810 |a 974858918 |a 981867421 |a 1005640840 |a 1018074754 |a 1042321545 |a 1044287913 |a 1049144969 |a 1053512930 |a 1056432646 |a 1058114072 |a 1060874127 |a 1083565450 |a 1114386408 |a 1153450756 | ||
| 020 | |a 9781849687232 |q (e-book) | ||
| 020 | |a 1849687234 |q (e-book) | ||
| 020 | |a 1849687226 | ||
| 020 | |a 9781849687225 | ||
| 020 | |z 9781849687225 | ||
| 029 | 1 | |a AU@ |b 000050155565 | |
| 029 | 1 | |a DEBSZ |b 378299522 | |
| 029 | 1 | |a NZ1 |b 15024267 | |
| 035 | |a (OCoLC)797834406 |z (OCoLC)810455880 |z (OCoLC)961490116 |z (OCoLC)962626187 |z (OCoLC)974762810 |z (OCoLC)974858918 |z (OCoLC)981867421 |z (OCoLC)1005640840 |z (OCoLC)1018074754 |z (OCoLC)1042321545 |z (OCoLC)1044287913 |z (OCoLC)1049144969 |z (OCoLC)1053512930 |z (OCoLC)1056432646 |z (OCoLC)1058114072 |z (OCoLC)1060874127 |z (OCoLC)1083565450 |z (OCoLC)1114386408 |z (OCoLC)1153450756 | ||
| 037 | |a CL0500000165 |b Safari Books Online | ||
| 050 | 4 | |a HF5548.323.O73 |b G87 2012eb | |
| 082 | 0 | 4 | |a 004.35 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Gupta, Saurabh K. | |
| 245 | 1 | 0 | |a Oracle advanced PL/SQL developer professional guide : |b master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination / |c Saurabh K. Gupta. |
| 260 | |a Birmingham, U.K. : |b Packt Pub., |c 2012. | ||
| 300 | |a 1 online resource (viii, 416 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 340 | |g polychrome. |2 rdacc |0 http://rdaregistry.info/termList/RDAColourContent/1003 | ||
| 347 | |a data file | ||
| 380 | |a Handbook | ||
| 490 | 1 | |a Enterprise : professional expertise distilled | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 the direct and indirect dependencies; Dependency metadata; Dependency issues and enhancements; Reviewing Oracle-supplied packages; Summary | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 0 | |a Oracle (Computer file) |x Examinations |v Study guides. |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |0 (OCoLC)fst01363816 |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a XML (Document markup language) | |
| 650 | 0 | |a Database management |v Handbooks, manuals, etc. | |
| 650 | 0 | |a Relational databases |v Handbooks, manuals, etc. | |
| 650 | 0 | |a Electronic data processing personnel |x Certification |v Study guides. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a XML (Langage de balisage) | |
| 650 | 6 | |a Bases de données |x Gestion |v Guides, manuels, etc. | |
| 650 | 6 | |a Bases de données relationnelles |v Guides, manuels, etc. | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 650 | 7 | |a Electronic data processing personnel |x Certification. |2 fast |0 (OCoLC)fst00907100 | |
| 650 | 7 | |a Examinations. |2 fast |0 (OCoLC)fst00917492 | |
| 650 | 7 | |a Relational databases. |2 fast |0 (OCoLC)fst01093575 | |
| 650 | 7 | |a SQL (Computer program language) |2 fast |0 (OCoLC)fst01102869 | |
| 650 | 7 | |a XML (Document markup language) |2 fast |0 (OCoLC)fst01181899 | |
| 655 | 2 | |a Handbook | |
| 655 | 7 | |a examination study guides. |2 aat | |
| 655 | 7 | |a Handbooks and manuals. |2 fast |0 (OCoLC)fst01423877 | |
| 655 | 7 | |a Study guides. |2 fast |0 (OCoLC)fst01423888 | |
| 655 | 7 | |a Handbooks and manuals. |2 lcgft | |
| 655 | 7 | |a Study guides. |2 lcgft | |
| 655 | 7 | |a Guides et manuels. |2 rvmgf | |
| 655 | 7 | |a Guides de l'étudiant. |2 rvmgf | |
| 830 | 0 | |a Enterprise : professional expertise distilled. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781849687225/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 936 | |a BATCHLOAD | ||
| 938 | |a ebrary |b EBRY |n ebr10563884 | ||
| 994 | |a 92 |b IZTAP | ||