- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 456
- Dostępne formaty:
-
ePubMobi
Opis ebooka: 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 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, it contains:
- A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running
- Extensive coverage of security topics for DBAs: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, TDE); Row-Level Security(RLS), Fine-Grained Auditing (FGA); and random value generation
- Methods for DBAs to improve query and database performance with cursors and table functions
- Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution
Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.
DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.
Wybrane bestsellery
-
Relacyjne bazy danych są wszędzie wokół nas, a do podstawowych umiejętności wymaganych od współczesnych programistów należy dobra znajomość języka SQL. Na świecie nie ma jednak osób, którym nie zdarza się czegoś zapomnieć. Jeśli potrzebujesz pomocy w codziennej pracy lub chcesz odświeżyć wiedzę n...(6.90 zł najniższa cena z 30 dni)
8.49 zł
17.00 zł(-50%) -
Debugging Machine Learning Models with Python equips you with the skills needed to transition from a machine learning beginner to a specialist. It guides you through the tools, theoretical concepts, Python modules, and libraries for bringing a high-quality model into production and identifying op...
Debugging Machine Learning Models with Python. Develop high-performance, low-bias, and explainable machine learning and deep learning models Debugging Machine Learning Models with Python. Develop high-performance, low-bias, and explainable machine learning and deep learning models
-
As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides sys...(245.65 zł najniższa cena z 30 dni)
245.65 zł
289.00 zł(-15%) -
Database administrators invest a great deal of time planning backend databases to support apps. Planning around a database involves several considerations such as high availability, security, performance requirements, and disaster recovery. This book covers a series of concepts with screenshots a...
Oracle Autonomous Database in Enterprise Architecture. Utilize Oracle Cloud Infrastructure Autonomous Databases for better consolidation, automation, and security Oracle Autonomous Database in Enterprise Architecture. Utilize Oracle Cloud Infrastructure Autonomous Databases for better consolidation, automation, and security
-
Zestaw aplikacji Oracle jest wykorzystywany przez wiele znaczących przedsiębiorstw biznesowych oraz organizacji sektora publicznego na całym świecie. Oracle E-Business Suite jest najbardziej wszechstronnym zestawem zintegrowanych aplikacji dla dużych przedsiębiorstw, umożliwiającym podejmowanie l...
Integrowanie Oracle E-Business Suite R12 oraz tworzenie i rozszerzanie OA Framework. Poradnik praktyczny. Poradnik praktyczny Integrowanie Oracle E-Business Suite R12 oraz tworzenie i rozszerzanie OA Framework. Poradnik praktyczny. Poradnik praktyczny
(71.82 zł najniższa cena z 30 dni)71.82 zł
79.80 zł(-10%) -
Oracle Enterprise Manager to wszechstronne i kompleksowe narzędzie dla każdego administratora, z którego konsoli możemy zarządzać i monitorować wszystkie warstwy infrastruktury przedsiębiorstwa, takie jak pamięci masowe, serwery, systemy operacyjne, oprogramowanie pośrednie i inne. Prezen...
Administrowanie Oracle Enterprise Manager 12c. Poradnik praktyczny Administrowanie Oracle Enterprise Manager 12c. Poradnik praktyczny
(15.90 zł najniższa cena z 30 dni)62.37 zł
69.30 zł(-10%) -
Systemy oparte na Linuksie stanowią świetną alternatywę dla Windowsa. Szczególnie dobrze sprawdzają się w środowiskach serwerowych, dla których wsparcie zapewniają największe firmy komputerowe, takie jak IBM, Oracle, Dell czy Microsoft. Tak, także ta ostatnia korporacja docenia zalety oprogramowa...
Linux Server. Kurs video. Usługi serwerowe, skrypty i środowisko graficzne Linux Server. Kurs video. Usługi serwerowe, skrypty i środowisko graficzne
(39.90 zł najniższa cena z 30 dni)59.50 zł
119.00 zł(-50%) -
Ta książka szczególnie przyda się architektom technologii informatycznych, administratorom baz danych i projektantom, którzy do wykonywania swoich obowiązków potrzebują wiedzy o najświeższych rozwiązaniach z dziedziny technologii baz danych. Omówiono tu najnowsze, wykorzystywane obecnie technolog...
NoSQL, NewSQL i BigData. Bazy danych następnej generacji NoSQL, NewSQL i BigData. Bazy danych następnej generacji
(19.90 zł najniższa cena z 30 dni)27.45 zł
54.90 zł(-50%) -
Błyskawicznie zaczniesz korzystać z zaawansowanych technik bazodanowych. Nauczysz się używać widoków, wykonywać transakcje, konfigurować połączenia sieciowe i stosować rozszerzenia języka SQL dostępne w bazach danych Oracle i MS SQL Server.(24.90 zł najniższa cena z 30 dni)
34.50 zł
69.00 zł(-50%) -
Niniejsza książka jest skierowana do osób, które chcą możliwie jak najszybciej rozpocząć pracę z systemami Oracle i językiem PL/SQL. Jest to przystępnie napisany, bardzo praktyczny podręcznik, który do maksimum ułatwia szybkie przyswojenie niezbędnej wiedzy. Książka zawiera 26 lekcji. Przyswojeni...(14.90 zł najniższa cena z 30 dni)
22.45 zł
44.90 zł(-50%)
Arup Nanda, Steven Feuerstein - pozostałe książki
-
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.Whether you’re a developer or database administrator, when yo...
Oracle PL/SQL Language Pocket Reference. 5th Edition Oracle PL/SQL Language Pocket Reference. 5th Edition
(46.74 zł najniższa cena z 30 dni)50.91 zł
59.90 zł(-15%) -
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release...(203.15 zł najniższa cena z 30 dni)
203.15 zł
239.00 zł(-15%) -
In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering ...(84.92 zł najniższa cena z 30 dni)
92.65 zł
109.00 zł(-15%) -
For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to ...(186.15 zł najniższa cena z 30 dni)
194.65 zł
229.00 zł(-15%) -
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and eff...
Oracle PL/SQL Best Practices. Optimizing Oracle Code Oracle PL/SQL Best Practices. Optimizing Oracle Code
(50.91 zł najniższa cena z 30 dni)50.91 zł
59.90 zł(-15%) -
However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer's Workbook is a different kind of animal! It's designed to engage you actively, to get you solving programming problems ...(160.65 zł najniższa cena z 30 dni)
160.65 zł
189.00 zł(-15%) -
The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed qui...(126.65 zł najniższa cena z 30 dni)
135.15 zł
159.00 zł(-15%)
Ebooka "Oracle PL/SQL for DBAs" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "Oracle PL/SQL for DBAs" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "Oracle PL/SQL for DBAs" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-493-7899-8, 9781449378998
- Data wydania ebooka:
- 2005-10-31 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 1.4MB
- Rozmiar pliku Mobi:
- 2.8MB
Spis treści ebooka
- Oracle PL/SQL for DBAs
- SPECIAL OFFER: Upgrade this ebook with OReilly
- A Note Regarding Supplemental Files
- Preface
- PL/SQL for DBAs
- Securing the Database
- Optimizing Performance
- Fully Leveraging Oracle Utilities and Features
- Mentoring New Developers and DBAs
- PL/SQL for DBAs
- About This Book
- Conventions Used in This Book
- About PL/SQL Versions
- Resources for Developing PL/SQL Expertise
- The OReilly PL/SQL Series
- PL/SQL on the Internet
- About the Code
- Using Code Examples
- Comments and Questions
- Safari Enabled
- Acknowledgments
- 1. Introduction to PL/SQL
- 1.1. What Is PL/SQL?
- 1.2. Basic PL/SQL Syntax Elements
- 1.2.1. PL/SQL Block Structure
- 1.2.1.1. Sections of the block
- 1.2.1.2. Anonymous blocks
- 1.2.1. PL/SQL Block Structure
- 1.2.2. The PL/SQL Character Set
- 1.2.3. Identifiers
- 1.2.3.1. NULLs
- 1.2.4. Literals
- 1.2.4.1. String literals
- 1.2.4.2. Numeric literals
- 1.2.4.3. Boolean literals
- 1.2.5. The Semicolon Delimiter
- 1.2.6. Comments
- 1.2.6.1. Single-line comment syntax
- 1.2.6.2. Multi-line comment syntax
- 1.3. Program Data
- 1.3.1. Types of PL/SQL Datatypes
- 1.3.1.1. Character data
- 1.3.1.2. Numbers
- 1.3.1.3. Dates, timestamps, and intervals
- 1.3.1.4. Booleans
- 1.3.1.5. Binary data
- 1.3.1.6. ROWIDs
- 1.3.1.7. REF CURSOR datatype
- 1.3.1.8. Internet datatypes
- 1.3.1.9. "Any" datatypes
- 1.3.1. Types of PL/SQL Datatypes
- 1.3.2. Declaring Program Data
- 1.3.2.1. Declaring a variable
- 1.3.2.2. Declaring constants
- 1.3.2.3. Anchored declarations
- 1.4. Control Statements
- 1.4.1. IF Statements
- 1.4.2. CASE Statements and Expressions
- 1.4.2.1. Simple CASE statement
- 1.4.2.2. Searched CASE statement
- 1.5. Loops in PL/SQL
- 1.5.1. Simple Loop
- 1.5.2. FOR Loop
- 1.5.3. WHILE Loop
- 1.6. Exception Handling
- 1.6.1. Defining Exceptions
- 1.6.2. Raising Exceptions
- 1.6.2.1. RAISE statement
- 1.6.2.2. Using RAISE_APPLICATION_ERROR
- 1.6.3. Handling Exceptions
- 1.6.3.1. Built-in error functions
- 1.6.3.2. Unhandled exceptions
- 1.6.3.3. Propagation of an unhandled exception
- 1.7. Records
- 1.7.1. Declaring Records
- 1.7.2. Working with Records
- 1.7.2.1. Record-level operations
- 1.7.2.2. Field-level operations
- 1.8. Collections
- 1.8.1. Types of Collections
- 1.8.2. Working with Collections
- 1.8.2.1. Using an associative array
- 1.8.2.2. Using a nested table
- 1.8.2.3. Using a VARRAY
- 1.8.3. Collection Methods (Built-ins)
- 1.9. Procedures, Functions, and Packages
- 1.9.1. Procedures
- 1.9.1.1. Structure of a procedure
- 1.9.1.2. Calling a procedure
- 1.9.1. Procedures
- 1.9.2. Functions
- 1.9.2.1. Structure of a function
- 1.9.2.2. Calling a function
- 1.9.3. Parameters
- 1.9.3.1. Defining parameters
- 1.9.3.2. Actual and formal parameters
- 1.9.3.3. Parameter modes
- 1.9.4. Packages
- 1.9.4.1. Rules for building packages
- 1.9.4.2. Rules for calling packaged elements
- 1.9.4.3. Package data
- 1.10. Querying Data
- 1.10.1. Typical Query Operations
- 1.10.2. Cursor Attributes
- 1.10.3. Implicit Cursors
- 1.10.3.1. Error handling with implicit cursors
- 1.10.3.2. Implicit SQL cursor attributes
- 1.10.4. Explicit Cursors
- 1.10.5. BULK COLLECT
- 1.10.5.1. Limiting rows retrieved with BULK COLLECT
- 1.10.6. Cursor Variables and REF Cursors
- 1.10.6.1. Declaring REF CURSOR types
- 1.10.6.2. Declaring cursor variables
- 1.10.6.3. Opening cursor variables
- 1.10.6.4. Fetching from cursor variables
- 1.11. Changing Data
- 1.11.1. The INSERT Statement
- 1.11.2. The UPDATE Statement
- 1.11.3. The DELETE Statement
- 1.11.4. Cursor Attributes for DML Operations
- 1.11.5. DML and Exception Handling
- 1.11.6. Bulk DML with the FORALL Statement
- 1.11.6.1. Syntax of the FORALL Statement
- 1.11.6.2. FORALL Examples
- 1.12. Managing Transactions in PL/SQL
- 1.12.1. The COMMIT Statement
- 1.12.2. The ROLLBACK Statement
- 1.12.3. Autonomous Transactions
- 1.13. Database Triggers
- 1.13.1. DML Triggers
- 1.13.1.1. Transaction participation
- 1.13.1.2. Creating a DML trigger
- 1.13.1.3. The WHEN clause
- 1.13.1.4. Working with NEW and OLD pseudo -records
- 1.13.1.5. Determining the DML action within a trigger
- 1.13.1. DML Triggers
- 1.13.2. DDL Triggers
- 1.13.2.1. Creating a DDL Trigger
- 1.13.3. Database Event Triggers
- 1.13.3.1. Creating a database event trigger
- 1.14. Dynamic SQL and Dynamic PL/SQL
- 1.14.1. The EXECUTE IMMEDIATE Statement
- 1.14.2. The OPEN FOR Statement
- 1.14.3. Dynamic PL/SQL
- 1.15. Conclusion: From Fundamentals to Applying PL/SQL
- 2. Cursors
- 2.1. Reusing Cursors
- 2.1.1. Hard Parsing and Soft Parsing
- 2.1.2. Planning Cursor Use
- 2.1.3. How Oracle Decides To Share
- 2.1.4. PL/SQL Cursor Reformatting
- 2.1.5. Literal Values
- 2.1.6. Matching Algorithms
- 2.1.7. Text Matching Might Not Be Enough
- 2.1. Reusing Cursors
- 2.2. Using Explicit Cursors Versus Implicit Cursors
- 2.2.1. What's the Difference?
- 2.2.2. Cursor Attributes
- 2.2.3. Cursor Parameters
- 2.2.4. Mixing but not Matching
- 2.3. Soft-Closing Cursors
- 2.3.1. Explicit and Implicit Open Cursors
- 2.3.2. Native Dynamic SQL
- 2.4. Using Cursors for More Than Queries
- 2.4.1. Bulking Up
- 2.4.2. REF Cursors
- 2.4.2.1. Strong vs. weak REF cursors
- 2.4.2.2. REF cursor attributes
- 2.4.2.3. Dynamic data access
- 2.4.3. Cursor Parameters
- 2.4.4. Cursor Expressions
- 2.5. Conclusion
- 3. Table Functions
- 3.1. Why Table Functions?
- 3.1.1. A Simple Example
- 3.1.2. Calling a Table Function
- 3.1.3. Defining the Result Set Structure
- 3.1. Why Table Functions?
- 3.2. Cursors, Pipelining, and Nesting
- 3.2.1. Cursors
- 3.2.2. Pipelined Table Functions
- 3.2.3. Nested Table Functions
- 3.3. Parallelizing Table Functions
- 3.3.1. Taking Advantage of Parallel Query
- 3.3.2. Distributing Records
- 3.3.2.1. Random partitioning (PARTITION BY ANY)
- 3.3.2.2. Range partitioning (PARTITION BY RANGE)
- 3.3.2.3. Order streaming (ORDER)
- 3.3.2.4. Hash partitioning (PARTITION BY HASH)
- 3.3.2.5. Cluster streaming (CLUSTER)
- 3.3.3. Which Options Should You Choose?
- 3.3.4. What Does Oracle Do?
- 3.3.5. Number of PQ Servers to Use
- 3.4. Using Table Functions
- 3.4.1. The Function Header
- 3.4.2. The Basic Loop
- 3.4.3. Bulk Fetching the Criteria
- 3.4.4. Identifying Potential Repeats
- 3.4.5. Finding Genuine Repeats
- 3.4.6. The Final Function
- 3.4.7. Running the Function
- 3.4.8. The Totaling Function
- 3.5. Table Function Examples
- 3.5.1. Tracing
- 3.5.2. Establishing Time Limits
- 3.5.3. Enabling Nested Cursors
- 3.6. Tips for Working with Table Functions
- 3.6.1. The Case Against SYS_REFCURSOR
- 3.6.2. REF Cursors and Nesting
- 3.6.3. Applying Criteria
- 3.6.4. Standardizing Object and Collection Names
- 3.6.5. Beware of Unhandled Exceptions
- 3.6.6. Passing Objects Instead Of Cursors
- 3.6.7. Not Read Committed
- 3.7. Conclusion
- 4. Data Encryption and Hashing
- 4.1. Introduction to Encryption
- 4.1.1. Encryption Components
- 4.1.2. The Effects of Key Length
- 4.1.3. Symmetric Encryption Versus Asymmetric Encryption
- 4.1.4. Encryption Algorithms
- 4.1.5. Padding and Chaining
- 4.1. Introduction to Encryption
- 4.2. Encryption in Oracle9i Database
- 4.2.1. Encrypting Data
- 4.2.2. Specifying an Initialization Vector
- 4.2.3. Decrypting Data
- 4.2.4. Encrypting RAW Data
- 4.2.5. Performing Multi-Pass Encryption
- 4.2.6. Putting It Together
- 4.2.7. Generating Keys
- 4.2.7.1. Using DES3GETKEY
- 4.2.7.2. Using the key in encryption
- 4.2.8. A Practical Encryption Example
- 4.2.9. Storing the Keys
- 4.3. Encryption in Oracle Database 10g
- 4.3.1. Differences Between DBMS_CRYPTO and DBMS_OBFUSCATION_TOOLKIT
- 4.3.2. Generating Keys
- 4.3.3. Encrypting Data
- 4.3.3.1. Specifying the encryption type
- 4.3.3.2. Specifying chaining
- 4.3.3.3. Specifying padding
- 4.3.3.4. Combining options in the typ parameter
- 4.3.3.5. Handling and converting RAW data
- 4.3.3.6. Specifying the encryption algorithm
- 4.3.3.7. Putting it together
- 4.3.4. Decrypting Data
- 4.4. Key Management in Oracle Database 10g
- 4.4.1. Using a Single Key
- 4.4.2. Using a Key for Each Row
- 4.4.3. Using a Combined Approach
- 4.5. Transparent Data Encryption in Oracle Database 10g Release 2
- 4.5.1. Setting Up TDE
- 4.5.2. Adding TDE to Existing Tables
- 4.5.3. Performing TDE Key and Password Management
- 4.5.4. Adding Salt
- 4.6. Cryptographic Hashing
- 4.6.1. The Case of the Suspicious Sandwich
- 4.6.2. MD5 Hashing in Oracle9i Database
- 4.6.3. SHA-1 Hashing in Oracle Database 10g
- 4.6.4. Other Uses of Hashing
- 4.6.5. Message Authentication Code in Oracle Database 10g
- 4.7. Building a Practical Encryption System
- 4.8. Conclusion
- 5. Row-Level Security
- 5.1. Introduction to RLS
- 5.1.1. Why Learn About RLS?
- 5.1.2. A Simple Example
- 5.1. Introduction to RLS
- 5.2. Using RLS
- 5.2.1. Performing an Update Check
- 5.2.2. Static RLS Policies
- 5.2.2.1. Problems with static policies
- 5.2.2.2. Using a pragma
- 5.2.3. Defining a Dynamic Policy
- 5.2.4. Improving Performance
- 5.2.5. Controlling the Type of Table Access
- 5.3. RLS in Oracle Database 10g
- 5.3.1. Column-Sensitive RLS
- 5.3.2. Other Classes of Dynamism
- 5.3.2.1. Shared static policy
- 5.3.2.2. Context-sensitive policy
- 5.3.2.3. Shared context-sensitive policy
- 5.4. Troubleshooting RLS
- 5.4.1. Interpreting Errors
- 5.4.2. Direct-Path Operations
- 5.4.3. Checking the Query Rewrite
- 5.4.3.1. Data dictionary view
- 5.4.3.2. Event-based tracing
- 5.5. RLS Interactions with Other Oracle Features
- 5.6. Application Contexts
- 5.6.1. A Simple Example
- 5.6.2. The Security of Application Contexts
- 5.6.3. Contexts as Predicates in RLS
- 5.6.4. Identifying Non-Database Users
- 5.7. Conclusion
- 6. Fine-Grained Auditing
- 6.1. Introduction to FGA
- 6.1.1. What Is Auditing?
- 6.1.2. Why Learn About FGA?
- 6.1.3. A Simple Example
- 6.1.4. Auditing Differences Between Oracle Database Versions
- 6.1.5. What Else Does FGA Capture?
- 6.1.6. Using FGA with Flashback Query
- 6.1. Introduction to FGA
- 6.2. Customizing FGA
- 6.2.1. Specifying Audit Columns
- 6.2.2. Specifying Audit Conditions
- 6.2.3. Recording Bind Variables
- 6.2.3.1. Turning off bind variable capture
- 6.2.4. Specifying a Handler Module
- 6.2.4.1. Drawbacks with the default FGA approach
- 6.2.4.2. Creating a user-defined audit facility
- 6.3. Administering FGA
- 6.3.1. The DBA_AUDIT_POLICIES View
- 6.3.2. Using DBMS_FGA Procedures
- 6.3.2.1. The ADD_POLICY procedure
- 6.3.2.2. The DROP_POLICY procedure
- 6.3.2.3. The DISABLE_POLICY procedure
- 6.3.2.4. The ENABLE_POLICY procedure
- 6.4. FGA in Oracle Database 10g
- 6.4.1. Additional DML Statements
- 6.4.2. Additional Data Dictionary Views and Columns
- 6.4.2.1. The DBA_FGA_AUDIT_TRAIL view
- 6.4.2.2. The FLASHBACK_TRANSACTION_QUERY view
- 6.4.3. Combination of Columns
- 6.5. FGA and Other Oracle Auditing Techniques
- 6.5.1. FGA Compared with Triggers
- 6.5.1.1. The case for FGA
- 6.5.1.2. The case for triggers
- 6.5.1. FGA Compared with Triggers
- 6.5.2. FGA Compared with Regular Auditing
- 6.6. The Challenge of Non-Database Users
- 6.6.1. Client Identifier
- 6.6.2. Application Contexts
- 6.7. Troubleshooting FGA
- 6.8. Conclusion
- 7. Generating Random Values
- 7.1. Generating Random Numbers
- 7.1.1. Generating Positive Numbers
- 7.1.1.1. Controlling the precision
- 7.1.1.2. Controlling the range
- 7.1.1. Generating Positive Numbers
- 7.1.2. Generating Negative Numbers
- 7.1.2.1. The RANDOM function
- 7.1. Generating Random Numbers
- 7.1.3. Seeding Random Number Generation
- 7.2. Generating Characters
- 7.3. Checking for Randomness
- 7.4. Following Statistical Patterns
- 7.4.1. Generating Strings
- 7.4.2. Generating Random Values with NULLs
- 7.4.3. Generating Random Strings of Random Length
- 7.4.4. Putting It All Together
- 7.5. Conclusion
- 8. Scheduling
- 8.1. Why Schedule Jobs from Within Oracle?
- 8.2. Managing Jobs
- 8.2.1. A Simple Example
- 8.2.1.1. Running OS executables and anonymous blocks
- 8.2.1.2. DBA_SCHEDULER_JOBS view
- 8.2.1. A Simple Example
- 8.2.2. Simple Job Management
- 8.2.2.1. Enabling and disabling jobs
- 8.2.2.2. Stopping running jobs
- 8.2.2.3. Running a job
- 8.2.2.4. Dropping a job
- 8.3. Managing the Calendar and Schedule
- 8.3.1. Calendar Strings
- 8.3.1.1. Examples of calendar strings
- 8.3.1.2. Determining future calendar strings
- 8.3.1. Calendar Strings
- 8.3.2. Named Schedules
- 8.3.3. Owner of the Schedule
- 8.4. Managing Named Programs
- 8.4.1. Creating a Program
- 8.4.2. Running Other Users' Programs
- 8.5. Managing Priorities
- 8.5.1. Using the Resource Manager
- 8.5.2. Job Class
- 8.6. Managing Windows
- 8.6.1. Creating a Window
- 8.6.2. Prioritizing Windows
- 8.6.3. Specifying an End Date for Windows
- 8.6.4. Getting Information About Windows
- 8.6.5. Dropping Windows
- 8.6.6. Disabling and Enabling Windows
- 8.6.7. Forcing Windows Open and Closed
- 8.6.8. Window Groups
- 8.7. Managing Logging
- 8.7.1. Job Logs
- 8.7.1.1. DBA_SCHEDULER_JOB_LOG
- 8.7.1.2. DBA_SCHEDULER_JOB_RUN_DETAILS
- 8.7.1.3. Pruning the job log
- 8.7.1.4. Log levels
- 8.7.1.5. Setting the retention period
- 8.7.1. Job Logs
- 8.7.2. Window Logs
- 8.7.2.1. DBA_SCHEDULER_WINDOW_LOG
- 8.7.2.2. DBA_SCHEDULER_WINDOW_DETAILS
- 8.8. Managing Attributes
- 8.8.1. Jobs
- 8.8.2. Job Classes
- 8.8.3. Schedules
- 8.8.4. Programs
- 8.8.5. Windows
- 8.8.6. Window Groups
- 8.9. Conclusion
- A. Quick Reference
- A.1. DBMS_OBFUSCATION_TOOLKIT
- DES3GETKEY
- DESGETKEY
- DES3ENCRYPT
- DESENCRYPT
- DES3DECRYPT
- DESDECRYPT
- MD5
- A.1. DBMS_OBFUSCATION_TOOLKIT
- A.2. DBMS_CRYPTO
- GETRANDOMBYTES
- ENCRYPT
- DECRYPT
- HASH
- MAC
- A.3. DBMS_RLS
- Reference Section
- ADD_POLICY
- Reference Section
- Reference Section
- DROP_POLICY
- Reference Section
- ENABLE_POLICY
- Reference Section
- REFRESH_POLICY
- A.3.1. RLS Data Dictionary Views
- DBA_POLICIES
- A.4. DBMS_FGA
- Reference Section
- ADD_POLICY
- Reference Section
- Reference Section
- DROP_POLICY
- Reference Section
- DISABLE_POLICY
- Reference Section
- ENABLE_POLICY
- A.4.1. FGA Data Dictionary Views
- DBA_AUDIT_POLICIES
- DBA_FGA_AUDIT_TRAIL
- FLASHBACK_TRANSACTION_QUERY
- A.5. DBMS_RANDOM
- SEED
- VALUE
- STRING
- NORMAL
- A.6. DBMS_SCHEDULER
- Reference Section
- CREATE_JOB
- Reference Section
- Reference Section
- CREATE_JOB_CLASS
- Reference Section
- STOP_JOB
- Reference Section
- RUN_JOB
- Reference Section
- COPY_JOB
- Reference Section
- DISABLE
- Reference Section
- ENABLE
- Reference Section
- DROP_JOB
- Reference Section
- DROP_JOB_CLASS
- Reference Section
- CREATE_SCHEDULE
- Reference Section
- DROP_SCHEDULE
- Reference Section
- CREATE_WINDOW
- Reference Section
- CREATE_WINDOW_GROUP
- Reference Section
- ADD_WINDOW_GROUP_MEMBER
- Reference Section
- DROP_WINDOW
- Reference Section
- OPEN_WINDOW
- Reference Section
- CLOSE_WINDOW
- A.6.1. Scheduler Data Dictionary Views
- DBA_SCHEDULER_JOBS
- DBA_SCHEDULER_WINDOWS
- DBA_SCHEDULER_SCHEDULES
- DBA_SCHEDULER_PROGRAMS
- DBA_SCHEDULER_JOB_CLASSES
- DBA_SCHEDULER_WINDOW_GROUPS
- DBA_SCHEDULER_WINGROUP_MEMBERS
- DBA_SCHEDULER_JOB_LOG
- DBA_SCHEDULER_JOB_RUN_DETAILS
- DBA_SCHEDULER_RUNNING_JOBS
- About the Authors
- Colophon
- SPECIAL OFFER: Upgrade this ebook with OReilly
O'Reilly Media - inne książki
-
JavaScript gives web developers great power to create rich interactive browser experiences, and much of that power is provided by the browser itself. Modern web APIs enable web-based applications to come to life like never before, supporting actions that once required browser plug-ins. Some are s...(186.15 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
How will software development and operations have to change to meet the sustainability and green needs of the planet? And what does that imply for development organizations? In this eye-opening book, sustainable software advocates Anne Currie, Sarah Hsu, and Sara Bergman provide a unique overview...(160.65 zł najniższa cena z 30 dni)
177.65 zł
209.00 zł(-15%) -
OpenTelemetry is a revolution in observability data. Instead of running multiple uncoordinated pipelines, OpenTelemetry provides users with a single integrated stream of data, providing multiple sources of high-quality telemetry data: tracing, metrics, logs, RUM, eBPF, and more. This practical gu...(143.65 zł najniższa cena z 30 dni)
152.15 zł
179.00 zł(-15%) -
Interested in developing embedded systems? Since they don't tolerate inefficiency, these systems require a disciplined approach to programming. This easy-to-read guide helps you cultivate good development practices based on classic software design patterns and new patterns unique to embedded prog...(152.15 zł najniższa cena z 30 dni)
160.65 zł
189.00 zł(-15%) -
If you use Linux in your day-to-day work, then Linux Pocket Guide is the perfect on-the-job reference. This thoroughly updated 20th anniversary edition explains more than 200 Linux commands, including new commands for file handling, package management, version control, file format conversions, an...(92.65 zł najniższa cena z 30 dni)
101.15 zł
119.00 zł(-15%) -
Gain the valuable skills and techniques you need to accelerate the delivery of machine learning solutions. With this practical guide, data scientists, ML engineers, and their leaders will learn how to bridge the gap between data science and Lean product delivery in a practical and simple way. Dav...(245.65 zł najniższa cena z 30 dni)
245.65 zł
289.00 zł(-15%) -
This practical book provides a detailed explanation of the zero trust security model. Zero trust is a security paradigm shift that eliminates the concept of traditional perimeter-based security and requires you to "always assume breach" and "never trust but always verify." The updated edition off...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Decentralized finance (DeFi) is a rapidly growing field in fintech, having grown from $700 million to $100 billion over the past three years alone. But the lack of reliable information makes this area both risky and murky. In this practical book, experienced securities attorney Alexandra Damsker ...(203.15 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Whether you're a startup founder trying to disrupt an industry or an entrepreneur trying to provoke change from within, your biggest challenge is creating a product people actually want. Lean Analytics steers you in the right direction.This book shows you how to validate your initial idea, find t...(126.65 zł najniższa cena z 30 dni)
126.65 zł
149.00 zł(-15%) -
When it comes to building user interfaces on the web, React enables web developers to unlock a new world of possibilities. This practical book helps you take a deep dive into fundamental concepts of this JavaScript library, including JSX syntax and advanced patterns, the virtual DOM, React reconc...(194.65 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: Oracle PL/SQL for DBAs Arup Nanda, Steven Feuerstein (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.