Oracle built-in packages:
Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of ora...
Saved in:
Main Author: | |
---|---|
Other Authors: | , |
Format: | Electronic eBook |
Language: | English |
Published: |
Sebastopol
O'Reilly
1998
|
Subjects: | |
Links: | https://learning.oreilly.com/library/view/-/1565923758/?ar |
Summary: | Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein'sOracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:<li type="disc">DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.<li type="disc">DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.<li type="disc">DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. <li type="disc">DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book. Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively. The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides point-and-click access to the many files of source code and online documentation developed by the authors. The table of contents follows:PrefacePart I: Overview<li type="disc">1. IntroductionPart II: Application Development Packages<li type="disc"> Executing Dynamic SQL and PL/SQL <li type="disc"> Intersession Communication <li type="disc"> User Lock and Transaction Management <li type="disc"> Oracle Advanced Queuing <li type="disc"> Generating Output from PL/SQL Programs <li type="disc"> Defining an Application Profile <li type="disc"> Managing Large Objects <li type="disc"> Datatype Packages <li type="disc"> Miscellaneous PackagesPart III: Server Management Packages<li type="disc">Managing Session Information <li type="disc">Managing Server Resources <li type="disc">Job Scheduling in the DatabasePart IV: Distributed Database Packages<li type="disc">Snapshots <li type="disc">Advanced Replication <li type="disc">Conflict Resolution <li type="disc">Deferred Transactions and Remote Procedure CallsAppendix. What's on the companion disk? |
Item Description: | Print version record |
Physical Description: | 1 online resource (xxi, 931 pages) illustrations |
ISBN: | 9781565923751 1565923758 9781449397722 1449397727 |
Staff View
MARC
LEADER | 00000cam a22000002c 4500 | ||
---|---|---|---|
001 | ZDB-30-ORH-047372524 | ||
003 | DE-627-1 | ||
005 | 20240228113909.0 | ||
007 | cr uuu---uuuuu | ||
008 | 191023s1998 xx |||||o 00| ||eng c | ||
020 | |a 9781565923751 |9 978-1-56592-375-1 | ||
020 | |a 1565923758 |9 1-56592-375-8 | ||
020 | |a 9781449397722 |9 978-1-4493-9772-2 | ||
020 | |a 1449397727 |9 1-4493-9772-7 | ||
020 | |a 1565923758 |9 1-56592-375-8 | ||
035 | |a (DE-627-1)047372524 | ||
035 | |a (DE-599)KEP047372524 | ||
035 | |a (ORHE)1565923758 | ||
035 | |a (DE-627-1)047372524 | ||
040 | |a DE-627 |b ger |c DE-627 |e rda | ||
041 | |a eng | ||
082 | 0 | |a 005.75/65 |2 21 | |
100 | 1 | |a Feuerstein, Steven |e VerfasserIn |4 aut | |
245 | 1 | 0 | |a Oracle built-in packages |c Steven Feuerstein, Charles Dye, and John Beresniewicz |
264 | 1 | |a Sebastopol |b O'Reilly |c 1998 | |
300 | |a 1 online resource (xxi, 931 pages) |b illustrations | ||
336 | |a Text |b txt |2 rdacontent | ||
337 | |a Computermedien |b c |2 rdamedia | ||
338 | |a Online-Ressource |b cr |2 rdacarrier | ||
500 | |a Print version record | ||
520 | |a Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein'sOracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:<li type="disc">DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.<li type="disc">DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.<li type="disc">DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. <li type="disc">DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book. Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively. The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides point-and-click access to the many files of source code and online documentation developed by the authors. The table of contents follows:PrefacePart I: Overview<li type="disc">1. IntroductionPart II: Application Development Packages<li type="disc"> Executing Dynamic SQL and PL/SQL <li type="disc"> Intersession Communication <li type="disc"> User Lock and Transaction Management <li type="disc"> Oracle Advanced Queuing <li type="disc"> Generating Output from PL/SQL Programs <li type="disc"> Defining an Application Profile <li type="disc"> Managing Large Objects <li type="disc"> Datatype Packages <li type="disc"> Miscellaneous PackagesPart III: Server Management Packages<li type="disc">Managing Session Information <li type="disc">Managing Server Resources <li type="disc">Job Scheduling in the DatabasePart IV: Distributed Database Packages<li type="disc">Snapshots <li type="disc">Advanced Replication <li type="disc">Conflict Resolution <li type="disc">Deferred Transactions and Remote Procedure CallsAppendix. What's on the companion disk? | ||
630 | 2 | 0 | |a Oracle (Computer file) |
650 | 0 | |a Relational databases | |
650 | 4 | |a Oracle (Computer file) | |
650 | 4 | |a Bases de données relationnelles | |
650 | 4 | |a Oracle (Computer file) | |
650 | 4 | |a Relational databases | |
700 | 1 | |a Dye, Charles |e MitwirkendeR |4 ctb | |
700 | 1 | |a Beresniewicz, John |e MitwirkendeR |4 ctb | |
776 | 1 | |z 1565923758 | |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 1565923758 |
966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/1565923758/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
912 | |a ZDB-30-ORH | ||
912 | |a ZDB-30-ORH | ||
951 | |a BO | ||
912 | |a ZDB-30-ORH | ||
049 | |a DE-91 |
Record in the Search Index
DE-BY-TUM_katkey | ZDB-30-ORH-047372524 |
---|---|
_version_ | 1833357118853349377 |
adam_text | |
any_adam_object | |
author | Feuerstein, Steven |
author2 | Dye, Charles Beresniewicz, John |
author2_role | ctb ctb |
author2_variant | c d cd j b jb |
author_facet | Feuerstein, Steven Dye, Charles Beresniewicz, John |
author_role | aut |
author_sort | Feuerstein, Steven |
author_variant | s f sf |
building | Verbundindex |
bvnumber | localTUM |
collection | ZDB-30-ORH |
ctrlnum | (DE-627-1)047372524 (DE-599)KEP047372524 (ORHE)1565923758 |
dewey-full | 005.75/65 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.75/65 |
dewey-search | 005.75/65 |
dewey-sort | 15.75 265 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05292cam a22005052c 4500</leader><controlfield tag="001">ZDB-30-ORH-047372524</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228113909.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191023s1998 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781565923751</subfield><subfield code="9">978-1-56592-375-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1565923758</subfield><subfield code="9">1-56592-375-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781449397722</subfield><subfield code="9">978-1-4493-9772-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1449397727</subfield><subfield code="9">1-4493-9772-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1565923758</subfield><subfield code="9">1-56592-375-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047372524</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP047372524</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)1565923758</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)047372524</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">21</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Feuerstein, Steven</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle built-in packages</subfield><subfield code="c">Steven Feuerstein, Charles Dye, and John Beresniewicz</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Sebastopol</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">1998</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xxi, 931 pages)</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">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Print version record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein'sOracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:<li type="disc">DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.<li type="disc">DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.<li type="disc">DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. <li type="disc">DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book. Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively. The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides point-and-click access to the many files of source code and online documentation developed by the authors. The table of contents follows:PrefacePart I: Overview<li type="disc">1. IntroductionPart II: Application Development Packages<li type="disc"> Executing Dynamic SQL and PL/SQL <li type="disc"> Intersession Communication <li type="disc"> User Lock and Transaction Management <li type="disc"> Oracle Advanced Queuing <li type="disc"> Generating Output from PL/SQL Programs <li type="disc"> Defining an Application Profile <li type="disc"> Managing Large Objects <li type="disc"> Datatype Packages <li type="disc"> Miscellaneous PackagesPart III: Server Management Packages<li type="disc">Managing Session Information <li type="disc">Managing Server Resources <li type="disc">Job Scheduling in the DatabasePart IV: Distributed Database Packages<li type="disc">Snapshots <li type="disc">Advanced Replication <li type="disc">Conflict Resolution <li type="disc">Deferred Transactions and Remote Procedure CallsAppendix. What's on the companion disk?</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Dye, Charles</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Beresniewicz, John</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">1565923758</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">1565923758</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/1565923758/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
id | ZDB-30-ORH-047372524 |
illustrated | Illustrated |
indexdate | 2025-05-28T09:46:37Z |
institution | BVB |
isbn | 9781565923751 1565923758 9781449397722 1449397727 |
language | English |
open_access_boolean | |
owner | DE-91 DE-BY-TUM |
owner_facet | DE-91 DE-BY-TUM |
physical | 1 online resource (xxi, 931 pages) illustrations |
psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
publishDate | 1998 |
publishDateSearch | 1998 |
publishDateSort | 1998 |
publisher | O'Reilly |
record_format | marc |
spelling | Feuerstein, Steven VerfasserIn aut Oracle built-in packages Steven Feuerstein, Charles Dye, and John Beresniewicz Sebastopol O'Reilly 1998 1 online resource (xxi, 931 pages) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Print version record Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein'sOracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:<li type="disc">DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.<li type="disc">DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.<li type="disc">DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. <li type="disc">DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL book. There are also packages extensions for specific oracle environments such as distributed database. hence this book. Oracle Built-in Packages pulls together information about how to use the calling interface (API) to Oracle's Built-in Packages, and provides extensive examples on using the built-in packages effectively. The windows diskette included with the book contains the companion guide, an online tool developed by RevealNet, Inc., that provides point-and-click access to the many files of source code and online documentation developed by the authors. The table of contents follows:PrefacePart I: Overview<li type="disc">1. IntroductionPart II: Application Development Packages<li type="disc"> Executing Dynamic SQL and PL/SQL <li type="disc"> Intersession Communication <li type="disc"> User Lock and Transaction Management <li type="disc"> Oracle Advanced Queuing <li type="disc"> Generating Output from PL/SQL Programs <li type="disc"> Defining an Application Profile <li type="disc"> Managing Large Objects <li type="disc"> Datatype Packages <li type="disc"> Miscellaneous PackagesPart III: Server Management Packages<li type="disc">Managing Session Information <li type="disc">Managing Server Resources <li type="disc">Job Scheduling in the DatabasePart IV: Distributed Database Packages<li type="disc">Snapshots <li type="disc">Advanced Replication <li type="disc">Conflict Resolution <li type="disc">Deferred Transactions and Remote Procedure CallsAppendix. What's on the companion disk? Oracle (Computer file) Relational databases Bases de données relationnelles Dye, Charles MitwirkendeR ctb Beresniewicz, John MitwirkendeR ctb 1565923758 Erscheint auch als Druck-Ausgabe 1565923758 |
spellingShingle | Feuerstein, Steven Oracle built-in packages Oracle (Computer file) Relational databases Bases de données relationnelles |
title | Oracle built-in packages |
title_auth | Oracle built-in packages |
title_exact_search | Oracle built-in packages |
title_full | Oracle built-in packages Steven Feuerstein, Charles Dye, and John Beresniewicz |
title_fullStr | Oracle built-in packages Steven Feuerstein, Charles Dye, and John Beresniewicz |
title_full_unstemmed | Oracle built-in packages Steven Feuerstein, Charles Dye, and John Beresniewicz |
title_short | Oracle built-in packages |
title_sort | oracle built in packages |
topic | Oracle (Computer file) Relational databases Bases de données relationnelles |
topic_facet | Oracle (Computer file) Relational databases Bases de données relationnelles |
work_keys_str_mv | AT feuersteinsteven oraclebuiltinpackages AT dyecharles oraclebuiltinpackages AT beresniewiczjohn oraclebuiltinpackages |