Cargando…
Oracle PL/SQL for DBAs /
PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performa...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2005.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocm64549741 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 060306s2005 cau o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d BAKER |d OCLCQ |d JTD |d WAU |d CEF |d OCLCQ |d DEBSZ |d OCLCQ |d E7B |d EBLCP |d MHW |d OCLCF |d OCLCQ |d CUSER |d N$T |d TEFOD |d NLE |d YDXCP |d TEFOD |d OCLCQ |d COO |d OCLCQ |d FEM |d OCLCQ |d MOQ |d RDF |d UKAHL |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 74459484 |a 326687457 |a 773211152 |a 859879791 |a 968010214 |a 969007441 | ||
| 020 | |a 0596005873 | ||
| 020 | |a 9780596005870 | ||
| 020 | |a 9780596519452 | ||
| 020 | |a 0596519451 | ||
| 020 | |a 9781449378998 | ||
| 020 | |a 1449378994 | ||
| 024 | 8 | |a 0596005873 | |
| 029 | 1 | |a DEBSZ |b 355369559 | |
| 029 | 1 | |a DEBSZ |b 405505388 | |
| 029 | 1 | |a HEBIS |b 291441408 | |
| 029 | 1 | |a AU@ |b 000069008105 | |
| 035 | |a (OCoLC)64549741 |z (OCoLC)74459484 |z (OCoLC)326687457 |z (OCoLC)773211152 |z (OCoLC)859879791 |z (OCoLC)968010214 |z (OCoLC)969007441 | ||
| 037 | |a CL0500000001 |b Safari Books Online | ||
| 037 | |a D5CD342C-17AF-4C91-BAE4-F45AC2DFC8ED |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 |b N36 2005 | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.7575 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Nanda, Arup. | |
| 245 | 1 | 0 | |a Oracle PL/SQL for DBAs / |c Arup Nanda and Steven Feuerstein. |
| 260 | |a Sebastopol, Calif. : |b O'Reilly, |c 2005. | ||
| 300 | |a 1 online resource (454 pages) | ||
| 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 | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur. Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples. | ||
| 542 | |f Copyright © O'Reilly Media, Inc. |g 2005. | ||
| 505 | 0 | |a Table of Contents; Preface; PL/SQL for DBAs; Securing the Database; Optimizing Performance; Fully Leveraging Oracle Utilities and Features; Mentoring New Developers and DBAs; About This Book; Conventions Used in This Book; About PL/SQL Versions; Resources for Developing PL/SQL Expertise; The O'Reilly PL/SQL Series; PL/SQL on the Internet; About the Code; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; Introduction to PL/SQL; What Is PL/SQL?; Basic PL/SQL Syntax Elements; PL/SQL Block Structure; Sections of the block; Anonymous blocks; The PL/SQL Character Set | |
| 505 | 8 | |a IdentifiersNULLs; Literals; String literals; Numeric literals; Boolean literals; The Semicolon Delimiter; Comments; Single-line comment syntax; Multi-line comment syntax; Program Data; Types of PL/SQL Datatypes; Character data; Numbers; Dates, timestamps, and intervals; Booleans; Binary data; ROWIDs; REF CURSOR datatype; Internet datatypes; "Any" datatypes; Declaring Program Data; Declaring a variable; Declaring constants; Anchored declarations; Control Statements; IF Statements; CASE Statements and Expressions; Simple CASE statement; Searched CASE statement; Loops in PL/SQL; Simple Loop | |
| 505 | 8 | |a FOR LoopWHILE Loop; Exception Handling; Defining Exceptions; Raising Exceptions; RAISE statement; Using RAISE_APPLICATION_ERROR; Handling Exceptions; Built-in error functions; Unhandled exceptions; Propagation of an unhandled exception; Records; Declaring Records; Working with Records; Record-level operations; Field-level operations; Collections; Types of Collections; Working with Collections; Using an associative array; Using a nested table; Using a VARRAY; Collection Methods (Built-ins); Procedures, Functions, and Packages; Procedures; Structure of a procedure; Calling a procedure | |
| 505 | 8 | |a FunctionsStructure of a function; Calling a function; Parameters; Defining parameters; Actual and formal parameters; Parameter modes; Packages; Rules for building packages; Rules for calling packaged elements; Package data; Querying Data; Typical Query Operations; Cursor Attributes; Implicit Cursors; Error handling with implicit cursors; Implicit SQL cursor attributes; Explicit Cursors; BULK COLLECT; Limiting rows retrieved with BULK COLLECT; Cursor Variables and REF Cursors; Declaring REF CURSOR types; Declaring cursor variables; Opening cursor variables; Fetching from cursor variables | |
| 505 | 8 | |a Changing DataThe INSERT Statement; The UPDATE Statement; The DELETE Statement; Cursor Attributes for DML Operations; DML and Exception Handling; Bulk DML with the FORALL Statement; Syntax of the FORALL Statement; FORALL Examples; Managing Transactions in PL/SQL; The COMMIT Statement; The ROLLBACK Statement; Autonomous Transactions; Database Triggers; DML Triggers; Transaction participation; Creating a DML trigger; The WHEN clause; Working with NEW and OLD pseudo-records; Determining the DML action within a trigger; DDL Triggers; Creating a DDL Trigger; Database Event Triggers | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a PL/SQL (Computer program language) | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a PL/SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a PL/SQL (Computer program language) |2 blmlsh | |
| 650 | 7 | |a Relational databases. |2 blmlsh | |
| 650 | 7 | |a PL/SQL (Computer program language) |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 700 | 1 | |a Feuerstein, Steven. | |
| 776 | 0 | 8 | |i Print version: |a Nanda, Arup. |t Oracle PL/SQL for DBAs. |d Sebastopol, Calif. : O'Reilly, 2005 |z 0596005873 |w (OCoLC)64552765 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/0596005873/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26847822 | ||
| 938 | |a Baker & Taylor |b BKTY |c 39.95 |d 29.96 |i 0596005873 |n 0006269505 |s active | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL540668 | ||
| 938 | |a ebrary |b EBRY |n ebr10759113 | ||
| 938 | |a EBSCOhost |b EBSC |n 414869 | ||
| 938 | |a YBP Library Services |b YANK |n 7407913 | ||
| 994 | |a 92 |b IZTAP | ||