|
|
|
|
| LEADER |
05161nmm a2200481 u 4500 |
| 001 |
EB001937981 |
| 003 |
EBX01000000000000001100883 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 0596005873
|
| 020 |
|
|
|a 9781449378998
|
| 020 |
|
|
|a 9780596005870
|
| 020 |
|
|
|a 9780596519452
|
| 020 |
|
|
|a 0596519451
|
| 050 |
|
4 |
|a QA76.9.D3
|
| 100 |
1 |
|
|a Nanda, Arup
|
| 245 |
0 |
0 |
|a Oracle PL/SQL for DBAs
|c Arup Nanda and Steven Feuerstein
|
| 260 |
|
|
|a Sebastopol, Calif.
|b O'Reilly
|c 2005
|
| 300 |
|
|
|a 454 pages
|
| 505 |
0 |
|
|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 |
0 |
|
|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
|
| 505 |
0 |
|
|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 |
0 |
|
|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 |
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
|
| 653 |
|
|
|a Oracle (Computer file) / http://id.loc.gov/authorities/names/n91015760
|
| 653 |
|
|
|a COMPUTERS / Data Processing / bisacsh
|
| 653 |
|
|
|a Oracle (Computer file) / blmlsh
|
| 653 |
|
|
|a Bases de données relationnelles
|
| 653 |
|
|
|a PL/SQL (Langage de programmation)
|
| 653 |
|
|
|a Oracle (Computer file) / fast
|
| 653 |
|
|
|a PL/SQL (Computer program language) / fast
|
| 653 |
|
|
|a Relational databases / fast
|
| 653 |
|
|
|a Relational databases / blmlsh
|
| 653 |
|
|
|a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768
|
| 653 |
|
|
|a PL/SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh96008008
|
| 653 |
|
|
|a PL/SQL (Computer program language) / blmlsh
|
| 700 |
1 |
|
|a Feuerstein, Steven
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/0596005873/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.7575
|
| 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
|