Advanced Oracle PL/SQL developer's guide :: master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c /
Annotation
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Burmingham, UK :
Packt Publishing,
2016.
|
| Ausgabe: | Second edition. |
| Schriftenreihe: | Professional experience distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Annotation |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource : illustrations. |
| ISBN: | 9781785282522 1785282522 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn941101385 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 160226s2016 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d TEFOD |d OCLCF |d TEFOD |d IDEBK |d VT2 |d KSU |d DEBSZ |d YDXCP |d DEBBG |d OCLCQ |d COO |d UOK |d CEF |d N$T |d FEM |d AGLDB |d BTN |d AUW |d INTCL |d MHW |d SNK |d RDF |d OCLCO |d OCLCQ |d OCLCO |d OCLCL |d OCLCQ | ||
| 019 | |a 940360586 |a 944310606 |a 968037339 |a 969061362 | ||
| 020 | |a 9781785282522 |q electronic bk. | ||
| 020 | |a 1785282522 |q electronic bk. | ||
| 020 | |z 9781785284809 | ||
| 020 | |z 1785284800 | ||
| 035 | |a (OCoLC)941101385 |z (OCoLC)940360586 |z (OCoLC)944310606 |z (OCoLC)968037339 |z (OCoLC)969061362 | ||
| 037 | |a CL0500000718 |b Safari Books Online | ||
| 037 | |a 4E2CF1B9-D03E-4906-8294-C414C2850DEB |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D26 | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 072 | 7 | |a COM |x 051280 |2 bisacsh | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 7 | |a 005.74 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Gupta, Saurabh K., |e author. | |
| 245 | 1 | 0 | |a Advanced Oracle PL/SQL developer's guide : |b master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / |c Saurabh K. Gupta. |
| 250 | |a Second edition. | ||
| 264 | 1 | |a Burmingham, UK : |b Packt Publishing, |c 2016. | |
| 300 | |a 1 online resource : |b illustrations. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 490 | 1 | |a Professional experience distilled | |
| 500 | |a Includes index. | ||
| 588 | |a Description based on online resource; title from cover page (Safari, viewed February 26, 2016). | ||
| 520 | 8 | |a Annotation |b The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the experienced Oracle professionals aspiring for Professional level by writing Oracle certification exam "1Z0-146: Oracle Database 11g: Advanced PL/SQL." The topics covered in the book are in line with the Oracle University prescription for 1Z0-146 certification, which justify the version updates to be advanced and not complex. The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications. The features like collections, external procedures, server side result caching, enforce row level security using VPD, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection | |
| 505 | 8 | |a Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables | |
| 505 | 8 | |a Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview | |
| 505 | 8 | |a Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache | |
| 505 | 8 | |a OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary | |
| 630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a PL/SQL (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh96008008 | |
| 650 | 0 | |a Java (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh95008574 | |
| 650 | 0 | |a Database design. |0 http://id.loc.gov/authorities/subjects/sh88004472 | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a PL/SQL (Langage de programmation) | |
| 650 | 6 | |a Java (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS / Databases / General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Java. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / SQL. |2 bisacsh | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Java (Computer program language) |2 fast | |
| 650 | 7 | |a PL/SQL (Computer program language) |2 fast | |
| 758 | |i has work: |a Advanced Oracle PL/SQL developer's guide (Text) |1 https://id.oclc.org/worldcat/entity/E39PCYKmGtW6rjXkJKwfwgFvQC |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Erscheint auch als: |n Druck-Ausgabe |
| 830 | 0 | |a Professional experience distilled. | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1171945 |3 Volltext |
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis34013834 | ||
| 938 | |a YBP Library Services |b YANK |n 12852116 | ||
| 938 | |a EBSCOhost |b EBSC |n 1171945 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn941101385 |
|---|---|
| _version_ | 1816882340731813888 |
| adam_text | |
| any_adam_object | |
| author | Gupta, Saurabh K. |
| author_facet | Gupta, Saurabh K. |
| author_role | aut |
| author_sort | Gupta, Saurabh K. |
| author_variant | s k g sk skg |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D26 |
| callnumber-search | QA76.9.D26 |
| callnumber-sort | QA 276.9 D26 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary |
| ctrlnum | (OCoLC)941101385 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | Second edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07873cam a2200793 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn941101385</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">160226s2016 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">TEFOD</subfield><subfield code="d">OCLCF</subfield><subfield code="d">TEFOD</subfield><subfield code="d">IDEBK</subfield><subfield code="d">VT2</subfield><subfield code="d">KSU</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">YDXCP</subfield><subfield code="d">DEBBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">UOK</subfield><subfield code="d">CEF</subfield><subfield code="d">N$T</subfield><subfield code="d">FEM</subfield><subfield code="d">AGLDB</subfield><subfield code="d">BTN</subfield><subfield code="d">AUW</subfield><subfield code="d">INTCL</subfield><subfield code="d">MHW</subfield><subfield code="d">SNK</subfield><subfield code="d">RDF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">940360586</subfield><subfield code="a">944310606</subfield><subfield code="a">968037339</subfield><subfield code="a">969061362</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781785282522</subfield><subfield code="q">electronic bk.</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1785282522</subfield><subfield code="q">electronic bk.</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781785284809</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1785284800</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)941101385</subfield><subfield code="z">(OCoLC)940360586</subfield><subfield code="z">(OCoLC)944310606</subfield><subfield code="z">(OCoLC)968037339</subfield><subfield code="z">(OCoLC)969061362</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000718</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">4E2CF1B9-D03E-4906-8294-C414C2850DEB</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D26</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051280</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Gupta, Saurabh K.,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Advanced Oracle PL/SQL developer's guide :</subfield><subfield code="b">master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c /</subfield><subfield code="c">Saurabh K. Gupta.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Burmingham, UK :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2016.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource :</subfield><subfield code="b">illustrations.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield><subfield code="2">rda</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Professional experience distilled</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="588" ind1=" " ind2=" "><subfield code="a">Description based on online resource; title from cover page (Safari, viewed February 26, 2016).</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation</subfield><subfield code="b">The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the experienced Oracle professionals aspiring for Professional level by writing Oracle certification exam "1Z0-146: Oracle Database 11g: Advanced PL/SQL." The topics covered in the book are in line with the Oracle University prescription for 1Z0-146 certification, which justify the version updates to be advanced and not complex. The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications. The features like collections, external procedures, server side result caching, enforce row level security using VPD, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Oracle (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n91015760</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">PL/SQL (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh96008008</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Java (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh95008574</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh88004472</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">PL/SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Java (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Conception.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Databases / General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Java.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database design</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Java (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">PL/SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Advanced Oracle PL/SQL developer's guide (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCYKmGtW6rjXkJKwfwgFvQC</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als:</subfield><subfield code="n">Druck-Ausgabe</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional experience distilled.</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1171945</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis34013834</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12852116</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1171945</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn941101385 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:27:04Z |
| institution | BVB |
| isbn | 9781785282522 1785282522 |
| language | English |
| oclc_num | 941101385 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource : illustrations. |
| psigel | ZDB-4-EBA |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Professional experience distilled. |
| series2 | Professional experience distilled |
| spelling | Gupta, Saurabh K., author. Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / Saurabh K. Gupta. Second edition. Burmingham, UK : Packt Publishing, 2016. 1 online resource : illustrations. text txt rdacontent computer c rdamedia online resource cr rdacarrier text file rda Professional experience distilled Includes index. Description based on online resource; title from cover page (Safari, viewed February 26, 2016). Annotation The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the experienced Oracle professionals aspiring for Professional level by writing Oracle certification exam "1Z0-146: Oracle Database 11g: Advanced PL/SQL." The topics covered in the book are in line with the Oracle University prescription for 1Z0-146 certification, which justify the version updates to be advanced and not complex. The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications. The features like collections, external procedures, server side result caching, enforce row level security using VPD, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast PL/SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh96008008 Java (Computer program language) http://id.loc.gov/authorities/subjects/sh95008574 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database management. http://id.loc.gov/authorities/subjects/sh85035848 PL/SQL (Langage de programmation) Java (Langage de programmation) Bases de données Conception. Bases de données Gestion. COMPUTERS / Databases / General. bisacsh COMPUTERS / Programming Languages / Java. bisacsh COMPUTERS / Programming Languages / SQL. bisacsh Database design fast Database management fast Java (Computer program language) fast PL/SQL (Computer program language) fast has work: Advanced Oracle PL/SQL developer's guide (Text) https://id.oclc.org/worldcat/entity/E39PCYKmGtW6rjXkJKwfwgFvQC https://id.oclc.org/worldcat/ontology/hasWork Erscheint auch als: Druck-Ausgabe Professional experience distilled. FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1171945 Volltext |
| spellingShingle | Gupta, Saurabh K. Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / Professional experience distilled. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast PL/SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh96008008 Java (Computer program language) http://id.loc.gov/authorities/subjects/sh95008574 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database management. http://id.loc.gov/authorities/subjects/sh85035848 PL/SQL (Langage de programmation) Java (Langage de programmation) Bases de données Conception. Bases de données Gestion. COMPUTERS / Databases / General. bisacsh COMPUTERS / Programming Languages / Java. bisacsh COMPUTERS / Programming Languages / SQL. bisacsh Database design fast Database management fast Java (Computer program language) fast PL/SQL (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh96008008 http://id.loc.gov/authorities/subjects/sh95008574 http://id.loc.gov/authorities/subjects/sh88004472 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / |
| title_auth | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / |
| title_exact_search | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / |
| title_full | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / Saurabh K. Gupta. |
| title_fullStr | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / Saurabh K. Gupta. |
| title_full_unstemmed | Advanced Oracle PL/SQL developer's guide : master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / Saurabh K. Gupta. |
| title_short | Advanced Oracle PL/SQL developer's guide : |
| title_sort | advanced oracle pl sql developer s guide master the advanced concepts of pl sql for professional level certification and learn the new capabilities of oracle database 12c |
| title_sub | master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c / |
| topic | Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast PL/SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh96008008 Java (Computer program language) http://id.loc.gov/authorities/subjects/sh95008574 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database management. http://id.loc.gov/authorities/subjects/sh85035848 PL/SQL (Langage de programmation) Java (Langage de programmation) Bases de données Conception. Bases de données Gestion. COMPUTERS / Databases / General. bisacsh COMPUTERS / Programming Languages / Java. bisacsh COMPUTERS / Programming Languages / SQL. bisacsh Database design fast Database management fast Java (Computer program language) fast PL/SQL (Computer program language) fast |
| topic_facet | Oracle (Computer file) PL/SQL (Computer program language) Java (Computer program language) Database design. Database management. PL/SQL (Langage de programmation) Java (Langage de programmation) Bases de données Conception. Bases de données Gestion. COMPUTERS / Databases / General. COMPUTERS / Programming Languages / Java. COMPUTERS / Programming Languages / SQL. Database design Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1171945 |
| work_keys_str_mv | AT guptasaurabhk advancedoracleplsqldevelopersguidemastertheadvancedconceptsofplsqlforprofessionallevelcertificationandlearnthenewcapabilitiesoforacledatabase12c |