Hugendubel.info - Die B2B Online-Buchhandlung 

Merkliste
Die Merkliste ist leer.
Bitte warten - die Druckansicht der Seite wird vorbereitet.
Der Druckdialog öffnet sich, sobald die Seite vollständig geladen wurde.
Sollte die Druckvorschau unvollständig sein, bitte schliessen und "Erneut drucken" wählen.

Oracle PL/SQL for DBAs

Security, Scheduling, Performance & More
BuchKartoniert, Paperback
454 Seiten
Englisch
O'Reilly Mediaerschienen am06.12.2005
Covering the Oracle version, Oracle Database 10g Release 2 and containing code and usage examples, this title includes: a tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running; methods for DBAs to improve query and database performance with cursors and table functions; and more.mehr
Verfügbare Formate
BuchKartoniert, Paperback
EUR44,50
E-BookPDFDRM AdobeE-Book
EUR38,49
E-BookEPUBDRM AdobeE-Book
EUR29,99

Produkt

KlappentextCovering the Oracle version, Oracle Database 10g Release 2 and containing code and usage examples, this title includes: a tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running; methods for DBAs to improve query and database performance with cursors and table functions; and more.
Details
ISBN/GTIN978-0-596-00587-0
ProduktartBuch
EinbandartKartoniert, Paperback
FormatTrade Paperback (USA)
Erscheinungsjahr2005
Erscheinungsdatum06.12.2005
Seiten454 Seiten
SpracheEnglisch
MasseBreite 179 mm, Höhe 233 mm, Dicke 32 mm
Gewicht734 g
Artikel-Nr.11592713

Inhalt/Kritik

Inhaltsverzeichnis
Preface; PL/SQL for DBAs; About This Book; Conventions Used in This Book; About PL/SQL Versions; Resources for Developing PL/SQL Expertise; About the Code; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments;Chapter 1: Introduction to PL/SQL; 1.1 What Is PL/SQL?; 1.2 Basic PL/SQL Syntax Elements; 1.3 Program Data; 1.4 Control Statements; 1.5 Loops in PL/SQL; 1.6 Exception Handling; 1.7 Records; 1.8 Collections; 1.9 Procedures, Functions, and Packages; 1.10 Querying Data; 1.11 Changing Data; 1.12 Managing Transactions in PL/SQL; 1.13 Database Triggers; 1.14 Dynamic SQL and Dynamic PL/SQL; 1.15 Conclusion: From Fundamentals to Applying PL/SQL;Chapter 2: Cursors; 2.1 Reusing Cursors; 2.2 Using Explicit Cursors Versus Implicit Cursors; 2.3 Soft-Closing Cursors; 2.4 Using Cursors for More Than Queries; 2.5 Conclusion;Chapter 3: Table Functions; 3.1 Why Table Functions?; 3.2 Cursors, Pipelining, and Nesting; 3.3 Parallelizing Table Functions; 3.4 Using Table Functions; 3.5 Table Function Examples; 3.6 Tips for Working with Table Functions; 3.7 Conclusion;Chapter 4: Data Encryption and Hashing; 4.1 Introduction to Encryption; 4.2 Encryption in Oracle9i Database; 4.3 Encryption in Oracle Database 10g; 4.4 Key Management in Oracle Database 10g; 4.5 Transparent Data EncryptiondatabasesTransparent Data Encryption in Oracle Database 10g Release 2; 4.6 Cryptographic Hashing; 4.7 Building a Practical Encryption System; 4.8 Conclusion;Chapter 5: Row-Level Security; 5.1 Introduction to RLS; 5.2 Using RLS; 5.3 RLS in Oracle Database 10g; 5.4 Troubleshooting RLS; 5.5 RLS Interactions with Other Oracle Features; 5.6 Application Contexts; 5.7 Conclusion;Chapter 6: Fine-Grained Auditing; 6.1 Introduction to FGA; 6.2 Customizing FGA; 6.3 Administering FGA; 6.4 FGA in Oracle Database 10g; 6.5 FGA and Other Oracle Auditing Techniques; 6.6 The Challenge of Non-Database Users; 6.7 Troubleshooting FGA; 6.8 Conclusion;Chapter 7: Generating Random Values; 7.1 Generating Random Numbers; 7.2 Generating Characters; 7.3 Checking for Randomness; 7.4 Following Statistical Patterns; 7.5 Conclusion;Chapter 8: Scheduling; 8.1 Why Schedule Jobs from Within Oracle?; 8.2 Managing Jobs; 8.3 Managing the Calendar and Schedule; 8.4 Managing Named Programs; 8.5 Managing Priorities; 8.6 Managing Windows; 8.7 Managing Logging; 8.8 Managing Attributes; 8.9 Conclusion;Appendix A: Quick Reference; A.1 DBMS_OBFUSCATION_TOOLKIT; A.2 DBMS_CRYPTO; A.3 DBMS_RLS; A.4 DBMS_FGA; A.5 DBMS_RANDOM; A.6 DBMS_SCHEDULER;Colophon;mehr

Autor

Arup Nanda is a Senior Oracle DBA with 10 years of experience with a variety of projects using skills in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, Pro*C, C, Unix, NT, Shell Scripting. He has an MBA from Xavier Institute of Management, India.