Holdings: Oracle PL/SQL programming

Oracle PL/SQL programming: [covers versions through Oracle database 12c]

Saved in:

Bibliographic Details
Main Authors:	Feuerstein, Steven (Author), Pribyl, Bill (Author)
Format:	Book
Language:	English
Published:	Beijing [u.a.] O'Reilly 2014
Edition:	6. ed.
Subjects:	Oracle (Computer file) PL/SQL (Computer program language) Relational databases ORACLE 8.0 ORACLE 12c ORACLE 11g PL/SQL SQL ORACLE 9i ORACLE > Datenbanksystem ORACLE 8i Personal Computer
Online Access:	Inhaltsverzeichnis
Item Description:	Includes index.
Physical Description:	XXXVIII, 1340 S. Ill. 24 cm
ISBN:	9781449324452

Staff View

MARC


LEADER	00000nam a2200000zc 4500
001	BV041723411
003	DE-604
005	20150326
007	t
008	140307s2014 cc a\|\|\| \|\|\|\| 00\|\|\| eng d
020			\|a 9781449324452 \|9 978-1-449-32445-2
035			\|a (OCoLC)876169190
035			\|a (DE-599)BVBBV041723411
040			\|a DE-604 \|b ger \|e aacr
041	0		\|a eng
044			\|a cc \|c CN
049			\|a DE-526 \|a DE-11 \|a DE-91G \|a DE-2174
050		0	\|a QA76.73.S67
084			\|a ST 271 \|0 (DE-625)143639: \|2 rvk
084			\|a DAT 652f \|2 stub
100	1		\|a Feuerstein, Steven \|e Verfasser \|4 aut
245	1	0	\|a Oracle PL/SQL programming \|b [covers versions through Oracle database 12c] \|c Steven Feuerstein with Bill Pribyl
250			\|a 6. ed.
264		1	\|a Beijing [u.a.] \|b O'Reilly \|c 2014
300			\|a XXXVIII, 1340 S. \|b Ill. \|c 24 cm
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
500			\|a Includes index.
630	0	4	\|a Oracle (Computer file)
650		4	\|a PL/SQL (Computer program language)
650		4	\|a Relational databases
650	0	7	\|a ORACLE 8.0 \|0 (DE-588)4476381-5 \|2 gnd \|9 rswk-swf
650	0	7	\|a ORACLE 12c \|0 (DE-588)1045569658 \|2 gnd \|9 rswk-swf
650	0	7	\|a ORACLE 11g \|0 (DE-588)7601243-8 \|2 gnd \|9 rswk-swf
650	0	7	\|a PL/SQL \|0 (DE-588)4457669-9 \|2 gnd \|9 rswk-swf
650	0	7	\|a SQL \|0 (DE-588)4134010-3 \|2 gnd \|9 rswk-swf
650	0	7	\|a ORACLE 9i \|0 (DE-588)4646123-1 \|2 gnd \|9 rswk-swf
650	0	7	\|a ORACLE \|g Datenbanksystem \|0 (DE-588)4206222-6 \|2 gnd \|9 rswk-swf
650	0	7	\|a ORACLE 8i \|0 (DE-588)4542766-5 \|2 gnd \|9 rswk-swf
650	0	7	\|a Personal Computer \|0 (DE-588)4115533-6 \|2 gnd \|9 rswk-swf
689	0	0	\|a ORACLE 12c \|0 (DE-588)1045569658 \|D s
689	0	1	\|a PL/SQL \|0 (DE-588)4457669-9 \|D s
689	0		\|5 DE-604
689	1	0	\|a ORACLE \|g Datenbanksystem \|0 (DE-588)4206222-6 \|D s
689	1	1	\|a SQL \|0 (DE-588)4134010-3 \|D s
689	1		\|8 1\p \|5 DE-604
689	2	0	\|a ORACLE 8.0 \|0 (DE-588)4476381-5 \|D s
689	2	1	\|a PL/SQL \|0 (DE-588)4457669-9 \|D s
689	2		\|8 2\p \|5 DE-604
689	3	0	\|a ORACLE \|g Datenbanksystem \|0 (DE-588)4206222-6 \|D s
689	3	1	\|a Personal Computer \|0 (DE-588)4115533-6 \|D s
689	3		\|8 3\p \|5 DE-604
689	4	0	\|a ORACLE 11g \|0 (DE-588)7601243-8 \|D s
689	4	1	\|a PL/SQL \|0 (DE-588)4457669-9 \|D s
689	4		\|8 4\p \|5 DE-604
689	5	0	\|a ORACLE 9i \|0 (DE-588)4646123-1 \|D s
689	5		\|8 5\p \|5 DE-604
689	6	0	\|a ORACLE 8i \|0 (DE-588)4542766-5 \|D s
689	6		\|8 6\p \|5 DE-604
700	1		\|a Pribyl, Bill \|e Verfasser \|4 aut
856	4	2	\|m HBZ Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027170338&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-027170338
883	1		\|8 1\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 2\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 3\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 4\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 5\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 6\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk

Record in the Search Index

_version_	1804152002733670400
adam_text	Titel: Oracle PL/SQL programming Autor: Feuerstein, Steven Jahr: 2014 Table of Contents Preface......................................................................xxv Part I. Programming in PL/SQL 1. Introduction to PL/SQL....................................................... 3 What Is PL/SQL? 3 The Origins of PL/SQL 4 The Early Years of PL/SQL 4 Improved Application Portability 5 Improved Execution Authority and Transaction Integrity 5 Humble Beginnings, Steady Improvement 6 So This Is PL/SQL 7 Integration with SQL 7 Control and Conditional Logic 8 When Things Go Wrong 9 About PL/SQL Versions 11 Oracle Database 12c New PL/SQL Features 12 Resources for PL/SQL Developers 14 The O Reilly PL/SQL Series 15 PL/SQL on the Internet 16 Some Words of Advice 17 Don t Be in Such a Hurry! 17 Don t Be Afraid to Ask for Help 18 Take a Creative, Even Radical Approach 19 2. Creating and Running PL/SQL Code............................................21 Navigating the Database 21 Creating and Editing Source Code 22 SQLPlus 23 Starting Up SQLPlus Running a SQL Statement Running a PL/SQL Program Running a Script What Is the Current Directory ? Other SQLPlus Tasks Error Handling in SQLPlus Why You Will Love and Hate SQLPlus Performing Essential PL/SQL Tasks Creating a Stored Program Executing a Stored Program Showing Stored Programs Managing Grants and Synonyms for Stored Programs Dropping a Stored Program Hiding the Source Code of a Stored Program Editing Environments for PL/SQL Calling PL/SQL from Other Languages C: Using Oracles Precompiler (ProC) Java: Using JDBC Perl: Using Perl DBI and DBD::Oracle PHP: Using Oracle Extensions PL/SQL Server Pages And Where Else? 3. Language Fundamentals............................................ PL/SQL Block Structure Anonymous Blocks Named Blocks Nested Blocks Scope Qualify All References to Variables and Columns in SQL Statements Visibility The PL/SQL Character Set Identifiers Reserved Words Whitespace and Keywords Literals NULLs Embedding Single Quotes Inside a Literal String Numeric Literals Boolean Literals The Semicolon Delimiter 24 26 27 29 30 31 36 36 37 37 41 41 42 43 44 44 45 46 47 48 49 51 52 53 53 55 57 57 58 59 62 65 67 68 70 70 71 72 73 74 74 Comments 75 Single-Line Comment Syntax 75 Multiline Comment Syntax 76 The PRAGMA Keyword 76 Labels 77 Part II. PL/SQL Program Structure 4. Conditional and Sequential Control........................................... 83 IF Statements 83 The IF-THEN Combination 84 The IF-THEN-ELSE Combination 86 The IF-THEN-ELSIF Combination 87 Avoiding IF Syntax Gotchas 89 Nested IF Statements 90 Short-Circuit Evaluation 91 CASE Statements and Expressions 93 Simple CASE Statements 93 Searched CASE Statements 95 Nested CASE Statements 98 CASE Expressions 98 The GOTO Statement 100 The NULL Statement 101 Improving Program Readability 101 Using NULL After a Label 102 5. Iterative Processing with Loops..............................................105 Loop Basics 105 Examples of Different Loops 106 Structure of PL/SQL Loops 107 The Simple Loop 108 Terminating a Simple Loop: EXIT and EXIT WHEN 109 Emulating a REPEAT UNTIL Loop 110 The Intentionally Infinite Loop 111 The WHILE Loop 112 The Numeric FOR Loop 114 Rules for Numeric FOR Loops 114 Examples of Numeric FOR Loops 115 Handling Nontrivial Increments 116 The Cursor FOR Loop 117 Example of Cursor FOR Loops 118 Loop Labels 119 The CONTINUE Statement 120 Tips for Iterative Processing 123 Use Understandable Names for Loop Indexes 123 The Proper Way to Say Goodbye 124 Obtaining Information About FOR Loop Execution 126 SQL Statement as Loop 126 6. Exception Handlers......................129 Exception-Handling Concepts and Terminology 129 Defining Exceptions 122 Declaring Named Exceptions 122 Associating Exception Names with Error Codes 133 About Named System Exceptions 136 Scope of an Exception 139 Raising Exceptions 140 The RAISE Statement 140 Using RAISE_APPLICATION_ERROR 141 Handling Exceptions 143 Built-in Error Functions 144 Combining Multiple Exceptions in a Single Handler 149 Unhandled Exceptions 149 Propagation of Unhandled Exceptions 150 Continuing Past Exceptions 153 Writing WHEN OTHERS Handling Code 155 Building an Effective Error Management Architecture 157 Decide on Your Error Management Strategy 158 Standardize Handling of Different Types of Exceptions 159 Organize Use of Application-Specific Error Codes 162 Use Standardized Error Management Programs 163 Work with Your Own Exception Objects 165 Create Standard Templates for Common Error Handling 167 Making the Most of PL/SQL Error Management 169 Part III. PL/SQL Program Data 7. Working with Program Data...........................172 Naming Your Program Data 173 Overview of PL/SQL Datatypes 175 Character Data 176 Numbers 177 Dates, Timestamps, and Intervals 178 Booleans 178 Binary Data 179 ROWIDs 179 REF CURSORS 179 Internet Datatypes 180 Any Datatypes 180 User-Defined Datatypes 181 Declaring Program Data 181 Declaring a Variable 181 Declaring Constants 182 The NOT NULL Clause 183 Anchored Declarations 183 Anchoring to Cursors and Tables 185 Benefits of Anchored Declarations 186 Anchoring to NOT NULL Datatypes 188 Programmer-Defined Subtypes 188 Conversion Between Datatypes 189 Implicit Data Conversion 189 Explicit Datatype Conversion 192 8. Strings...................................................................199 String Datatypes 199 The VARCHAR2 Datatype 200 The CHAR Datatype 201 String Subtypes 202 Working with Strings 203 Specifying String Constants 203 Using Nonprintable Characters 205 Concatenating Strings 206 Dealing with Case 207 Traditional Searching, Extracting, and Replacing 210 Padding 213 Trimming 215 Regular Expression Searching, Extracting, and Replacing 216 Working with Empty Strings 227 Mixing CHAR and VARCHAR2 Values 229 String Function Quick Reference 231 9. Numbers.................................................. 241 Numeric Datatypes 241 The NUMBER Type 242 The PLS_INTEGER Type 242 The BINARYJNTEGER Type 248 The SIMPLEJNTEGER Type 249 The BINARY_FLOAT and BINARY_DOUBLE Types 251 The SIMPLE_FLOAT and SIMPLE_DOUBLE Types 256 Numeric Subtypes 2256 Number Conversions 257 The TO_NUMBER Function 258 The TO_CHAR Function 261 The CAST Function 267 Implicit Conversions 268 Numeric Operators 270 Numeric Functions 271 Rounding and Truncation Functions 271 Trigonometric Functions 272 Numeric Function Quick Reference 272 10. Dates and Hmestamps..................................................... 277 Datetime Datatypes 278 Declaring Datetime Variables 280 Choosing a Datetime Datatype 281 Getting the Current Date and Time 282 Interval Datatypes 284 Declaring INTERVAL Variables 286 When to Use INTERVALS 287 Datetime Conversions 289 From Strings to Datetimes 289 From Datetimes to Strings 292 Working with Time Zones 295 Requiring a Format Mask to Match Exactly 298 Easing Up on Exact Matches 299 Interpreting Two-Digit Years in a Sliding Window 299 Converting Time Zones to Character Strings 301 Padding Output with Fill Mode 302 Date and Timestamp Literals 302 Interval Conversions 304 Converting from Numbers to Intervals 304 Converting Strings to Intervals 305 Formatting Intervals for Display 306 Interval Literals 307 CAST and EXTRACT 308 The CAST Function 308 The EXTRACT Function 310 Datetime Arithmetic 311 Date Arithmetic with Intervals and Datetimes 311 Date Arithmetic with DATE Datatypes 312 Computing the Interval Between Two Datetimes 313 Mixing DATEs and TIMESTAMPs 316 Adding and Subtracting Intervals 317 Multiplying and Dividing Intervals 317 Using Unconstrained INTERVAL Types 318 Date/Time Function Quick Reference 319 11. Records............................................ 323 Records in PL/SQL 323 Benefits of Using Records 324 Declaring Records 326 Programmer-Defined Records 327 Working with Records 330 Comparing Records 337 Trigger Pseudorecords 338 12. Collections............................................. 341 Collections Overview 342 Collections Concepts and Terminology 343 Types of Collections 345 Collection Examples 345 Where You Can Use Collections 349 Choosing a Collection Type 354 Collection Methods (Built-ins) 356 The COUNT Method 357 The DELETE Method 358 The EXISTS Method 359 The EXTEND Method 360 The FIRST and LAST Methods 361 The LIMIT Method 362 The PRIOR and NEXT Methods 362 The TRIM Method 363 Working with Collections 365 Declaring Collection Types 365 Declaring and Initializing Collection Variables 369 Populating Collections with Data 374 Accessing Data Inside a Collection 379 Using String-Indexed Collections 380 Collections of Complex Datatypes 385 Multilevel Collections 389 Working with Collections in SQL 398 Nested Table Multiset Operations 406 Testing Equality and Membership of Nested Tables 408 Checking for Membership of an Element in a Nested Table 409 Performing High-Level Set Operations 409 Handling Duplicates in a Nested Table 411 Maintaining Schema-Level Collections 412 Necessary Privileges 412 Collections and the Data Dictionary 413 13. Miscellaneous Datatypes.......................................... 415 The BOOLEAN Datatype 415 The RAW Datatype 417 The UROWID and ROWID Datatypes 417 Getting ROWIDs 418 Using ROWIDs 419 The LOB Datatypes 420 Working with LOBs 422 Understanding LOB Locators 423 Empty Versus NULL LOBs 425 Writing into a LOB 427 Reading from a LOB 430 BFILEs Are Different 431 SecureFiles Versus BasicFiles 436 Temporary LOBs 439 Native LOB Operations 442 LOB Conversion Functions 447 Predefined Object Types 447 The XMLType Type 448 The URI Types 451 The Any Types 453 Part IV. SQL in PL/SQL 14. DML and Transaction Management 461 DML in PL/SQL 462 A Quick Introduction to DML 462 Cursor Attributes for DML Operations 466 RETURNING Information from DML Statements 467 DML and Exception Handling 468 DML and Records 470 Transaction Management 473 The COMMIT Statement 474 The ROLLBACK Statement 474 The SAVEPOINT Statement 475 The SET TRANSACTION Statement 476 The LOCK TABLE Statement 476 Autonomous Transactions 477 Defining Autonomous Transactions 478 Rules and Restrictions on Autonomous Transactions 479 Transaction Visibility 480 When to Use Autonomous Transactions 481 Building an Autonomous Logging Mechanism 482 15. Data Retrieval............................................................ 485 Cursor Basics 486 Some Data Retrieval Terms 487 Typical Query Operations 488 Introduction to Cursor Attributes 489 Referencing PL/SQL Variables in a Cursor 492 Choosing Between Explicit and Implicit Cursors 493 Working with Implicit Cursors 494 Implicit Cursor Examples 495 Error Handling with Implicit Cursors 496 Implicit SQL Cursor Attributes 498 Working with Explicit Cursors 500 Declaring Explicit Cursors 501 Opening Explicit Cursors 504 Fetching from Explicit Cursors 505 Column Aliases in Explicit Cursors 507 Closing Explicit Cursors 508 Explicit Cursor Attributes 510 Cursor Parameters 512 SELECT...FOR UPDATE 515 Releasing Locks with COMMIT 516 The WHERE CURRENT OF Clause 518 Cursor Variables and REF CURSORS 519 Why Use Cursor Variables? 520 Similarities to Static Cursors 521 Declaring REF CURSOR Types 521 Declaring Cursor Variables 522 Opening Cursor Variables Fetching from Cursor Variables Rules for Cursor Variables Passing Cursor Variables as Arguments Cursor Variable Restrictions Cursor Expressions Using Cursor Expressions Restrictions on Cursor Expressions 16. Dynamic SQL and Dynamic PL/SQL................... NDS Statements The EXECUTE IMMEDIATE Statement The OPEN FOR Statement About the Four Dynamic SQL Methods Binding Variables Argument Modes Duplicate Placeholders Passing NULL Values Working with Objects and Collections Dynamic PL/SQL Build Dynamic PL/SQL Blocks Replace Repetitive Code with Dynamic Blocks Recommendations for NDS Use Invoker Rights for Shared Programs Anticipate and Handle Dynamic Errors Use Binding Rather than Concatenation Minimize the Dangers of Code Injection When to Use DBMS_SQL Obtain Information About Query Columns Meeting Method 4 Dynamic SQL Requirements Minimizing Parsing of Dynamic Cursors Oracle Database 1 lg New Dynamic SQL Features Enhanced Security for DBMS_SQL Part V. PL/SQL Application Construction 17. Procedures, Functions, and Parameters...... Modular Code Procedures Calling a Procedure The Procedure Header 523 524 527 530 532 533 534 536 537 538 538 543 548 550 551 553 554 555 557 558 560 561 561 562 564 566 569 569 571 578 579 584 591 592 593 596 596 The Procedure Body 596 The END Label 597 The RETURN Statement 597 Functions 597 Structure of a Function 598 The RETURN Datatype 601 The END Label 602 Calling a Function 603 Functions Without Parameters 604 The Function Header 604 The Function Body 605 The RETURN Statement 605 Parameters 607 Defining Parameters 608 Actual and Formal Parameters 608 Parameter Modes 609 Explicit Association of Actual and Formal Parameters in PL/SQL 613 The NOCOPY Parameter Mode Qualifier 617 Default Values 618 Local or Nested Modules 619 Benefits of Local Modularization 620 Scope of Local Modules 623 Sprucing Up Your Code with Nested Subprograms 623 Subprogram Overloading 624 Benefits of Overloading 625 Restrictions on Overloading 628 Overloading with Numeric Types 629 Forward Declarations 630 Advanced Topics 631 Calling Your Function from Inside SQL 631 Table Functions 637 Deterministic Functions 647 Implicit Cursor Results (Oracle Database 12c) 649 Go Forth and Modularize! 650 18. Packages.................................................................651 Why Packages? 651 Demonstrating the Power of the Package 652 Some Package-Related Concepts 655 Diagramming Privacy 657 Rules for Building Packages 658 The Package Specification 658 The Package Body 660 Initializing Packages 662 Rules for Calling Packaged Elements 666 Working with Package Data 667 Global Within a Single Oracle Session 668 Global Public Data 669 Packaged Cursors 669 Serializable Packages 674 When to Use Packages 677 Encapsulate Data Access 677 Avoid Hardcoding Literals 680 Improve Usability of Built-in Features 683 Group Together Logically Related Functionality 683 Cache Static Session Data 684 Packages and Object Types 685 19. Triggers............................................. 687 DML Triggers 688 DML Trigger Concepts 689 Creating a DML Trigger 691 DML Trigger Example: No Cheating Allowed! 696 Multiple Triggers of the Same Type 702 Who Follows Whom 703 Mutating Table Errors 705 Compound Triggers: Putting It All in One Place 706 DDL Triggers 710 Creating a DDL Trigger 710 Available Events 713 Available Attributes 713 Working with Events and Attributes 715 Dropping the Undroppable 718 The INSTEAD OF CREATE Trigger 719 Database Event Triggers 720 Creating a Database Event Trigger 721 The STARTUP Trigger 722 The SHUTDOWN Trigger 723 The LOGON Trigger 723 The LOGOFF Trigger 723 The SERVERERROR Trigger 724 INSTEAD OF Triggers 728 Creating an INSTEAD OF Tigger 728 The INSTEAD OF INSERT Trigger 730 The INSTEAD OF UPDATE Trigger 732 The INSTEAD OF DELETE Trigger 733 Populating the Tables 733 INSTEAD OF Triggers on Nested Tables 734 AFTER SUSPEND Triggers 736 Setting Up for the AFTER SUSPEND Trigger 736 Looking at the Actual Trigger 738 The ORA_SPACE_ERROR_INFO Function 739 The DBMS_RESUMABLE Package 740 Trapped Multiple Times 742 To Fix or Not to Fix? 743 Maintaining Triggers 743 Disabling, Enabling, and Dropping Triggers 743 Creating Disabled Triggers 744 Viewing Triggers 745 Checking the Validity of Triggers 746 20. Managing PL/SQL Code.....................................................749 Managing Code in the Database 750 Overview of Data Dictionary Views 751 Display Information About Stored Objects 753 Display and Search Source Code 753 Use Program Size to Determine Pinning Requirements 755 Obtain Properties of Stored Code 756 Analyze and Modify Trigger State Through Views 757 Analyze Argument Information 758 Analyze Identifier Usage (Oracle Database 11g s PL/Scope) 759 Managing Dependencies and Recompiling Code 762 Analyzing Dependencies with Data Dictionary Views 763 Fine-Grained Dependency (Oracle Database 11g) 767 Remote Dependencies 769 Limitations of Oracle s Remote Invocation Model 772 Recompiling Invalid Program Units 773 Compile-Time Warnings 777 A Quick Example 777 Enabling Compile-Time Warnings 778 Some Handy Warnings 780 Testing PL/SQL Programs 788 Typical, Tawdry Testing Techniques 789 General Advice for Testing PL/SQL Code 793 Automated Testing Options for PL/SQL 794 Tracing PL/SQL Execution 795 DBMS_UTILITY.FORMAT_CALL_STACK 796 UTL_CALL_STACK (Oracle Database 12c) 798 DBMS_APPLICATION_INFO 801 Tracing with opp_trace 803 The DBMS_TRACE Facility 804 Debugging PL/SQL Programs 808 The Wrong Way to Debug 809 Debugging Tips and Strategies 811 Using Whitelisting to Control Access to Program Units 816 Protecting Stored Code 8*8 Restrictions on and Limitations of Wrapping 818 Using the Wrap Executable 819 Dynamic Wrapping with DBMS_DDL 819 Guidelines for Working with Wrapped Code 821 Introduction to Edition-Based Redefinition (Oracle Database llg Release 2) 821 21. Optimizing PL/SQL Performance............................................. 825 Tools to Assist in Optimization 827 Analyzing Memory Usage 827 Identifying Bottlenecks in PL/SQL Code 827 Calculating Elapsed Time 833 Choosing the Fastest Program 834 Avoiding Infinite Loops 836 Performance-Related Warnings 837 The Optimizing Compiler 838 Insights on How the Optimizer Works 840 Runtime Optimization of Fetch Loops 843 Data Caching Techniques 844 Package-Based Caching 845 Deterministic Function Caching 850 THe Function Result Cache (Oracle Database 11g) 852 Caching Summary ggg Bulk Processing for Repeated SQL Statement Execution 869 High-Speed Querying with BULK COLLECT 870 High-Speed DML with FORALL 877 Improving Performance with Pipelined Table Functions 888 Replacing Row-Based Inserts with Pipelined Function-Based Loads 889 Tuning Merge Operations with Pipelined Functions 896 Asynchronous Data Unloading with Parallel Pipelined Functions 898 Performance Implications of Partitioning and Streaming Clauses in Parallel Pipelined Functions 902 Pipelined Functions and the Cost-Based Optimizer 903 Tuning Complex Data Loads with Pipelined Functions 909 A Final Word on Pipelined Functions 916 Specialized Optimization Techniques 917 Using the NOCOPY Parameter Mode Hint 917 Using the Right Datatype 921 Optimizing Function Performance in SQL (12.1 and higher) 922 Stepping Back for the Big Picture on Performance 923 22. 1/0 and PL/SQL............................................................ 925 Displaying Information 925 Enabling DBMS_OUTPUT 926 Write Lines to the Buffer 926 Read the Contents of the Buffer 927 Reading and Writing Files 929 The UTL FILE_DIR Parameter 929 Working with Oracle Directories 931 Open Files 932 Is the File Already Open? 934 Close Files 934 Read from Files 935 Write to Files 938 Copy Files 941 Delete Files 942 Rename and Move Files 943 Retrieve File Attributes 943 Sending Email 944 Oracle Prerequisites 945 Configuring Network Security 946 Send a Short (32,767 Bytes or Less) Plain-Text Message 947 Include Friendly Names in Email Addresses 948 Send a Plain-Text Message of Arbitrary Length 950 Send a Message with a Short (32,767 Bytes or Less) Attachment 951 Send a Small File (32,767 Bytes or Less) as an Attachment 953 Attach a File of Arbitrary Size 953 Working with Web-Based Data (HTTP) 956 Retrieve a Web Page in Pieces 956 Retrieve a Web Page into a LOB 958 Authenticate Using HTTP Username/Password 959 Retrieve an SSL-Encrypted Web Page (via HTTPS) 960 Submit Data to a Web Page via GET or POST 961 Disable Cookies or Make Cookies Persistent 965 Retrieve Data from an FTP Server 966 Use a Proxy Server Other Types of I/O Available in PL/SQL Database Pipes, Queues, and Alerts TCP Sockets Oracles Built-in Web Server Part VI. Advanced PL/SQL Topics 23. Application Security and PL/SQL......... Security Overview Encryption Key Length Algorithms Padding and Chaining The DBMS_CRYPTO Package Encrypting Data Encrypting LOBs SecureFiles Decrypting Data Performing Key Generation Performing Key Management Cryptographic Hashing Using Message Authentication Codes Using Transparent Data Encryption Transparent Tablespace Encryption Row-Level Security Why Learn About RLS? A Simple RLS Example Static Versus Dynamic Policies Using Column-Sensitive RLS RLS Debugging Application Contexts Using Application Contexts Security in Contexts Contexts as Predicates in RLS Identifying Nondatabase Users Eine-Grained Auditing Why Learn About EGA? A Simple EGA Example Access I low Many Columns? Checking the Audit Trail 966 967 967 968 968 971 971 973 974 975 977 977 979 982 982 983 984 985 991 993 994 997 999 1002 1003 1007 1012 1015 1019 1020 1022 1022 1026 1028 1029 1030 1032 1033 Using Bind Variables 1035 Using Handler Modules 1036 24. PL/SQL Architecture................................... 1039 DIANA 1039 How Oracle Executes PL/SQL Code 1040 An Example 1041 Compiler Limits 1044 The Default Packages of PL/SQL 1045 Execution Authority Models 1048 The Definer Rights Model 1049 The Invoker Rights Model 1054 Combining Rights Models 1056 Granting Roles to PL/SQL Program Units (Oracle Database 12c) 1057 Who Invoked Me? Functions (Oracle Database 12c) 1060 BEQUEATH CURRENTJJSER for Views (Oracle Database 12c) 1061 Constraining Invoker Rights Privileges (Oracle Database 12c) 1063 Conditional Compilation 1064 Examples of Conditional Compilation 1065 The Inquiry Directive 1066 The $IF Directive 1070 The $ERROR Directive 1072 Synchronizing Code with Packaged Constants 1072 Program-Specific Settings with Inquiry Directives 1073 Working with Postprocessed Code 1074 PL/SQL and Database Instance Memory 1076 The SGA, PGA, and UGA 1076 Cursors, Memory, and More 1077 Tips on Reducing Memory Use 1079 What to Do If You Run Out of Memory 1090 Native Compilation 1093 When to Run in Interpreted Mode 1094 When to Go Native 1094 Native Compilation and Database Release 1094 What You Need to Know 1095 25. Globalization and Localization in PL/SQL.....................................1097 Overview and Terminology 1099 Unicode Primer 1100 National Character Set Datatypes 1102 Character Encoding 1102 Globalization Support Parameters 1104 Unicode Functions 1105 Character Semantics 1111 String Sort Order 1115 Binary Sort 1116 Monolingual Sort 1117 Multilingual Sort Multilingual Information Retrieval 1120 IR and PL/SQL 1123 Date/Time 1126 Timestamp Datatypes 1126 Date/Time Formatting 1127 Currency Conversion 1131 Globalization Development Kit for PL/SQL 1133 UTL_118N Utility Package 1133 UTL_LMS Error-Handling Package 1136 GDK Implementation Options 1137 26. Object-Oriented Aspects of PL/SQL................... 1141 Introduction to Oracle s Object Features 1142 Object Types by Example 1144 Creating a Base Type 1144 Creating a Subtype 1146 Methods 1147 Invoking Supertype Methods in Oracle Database 1 lg and Later 1152 Storing, Retrieving, and Using Persistent Objects 1154 Evolution and Creation 1162 Back to Pointers? 1164 Generic Data: The ANY Types 1171 I Can Do It Myself 1276 Comparing Objects 1179 Object Views 1184 A Sample Relational System 1186 Object View with a Collection Attribute 1188 Object Subview 1191 Object View with Inverse Relationship 1192 INSTEAD OF Triggers 1193 Differences Between Object Views and Object Tables 1196 Maintaining Object Types and Object Views 1197 Data Dictionary 1197 Prtv,legos 1199 Concluding Thoughts from a (Mostly) Relational Developer 1201 27. Calling Java from PL/SQL.............. 1205 Oracle and Java 1205 Getting Ready to Use Java in Oracle 1207 Installing Java 1207 Building and Compiling Your Java Code 1208 Setting Permissions for Java Development and Execution 1209 A Simple Demonstration 1212 Finding the Java Functionality 1212 Building a Custom Java Class 1213 Compiling and Loading into Oracle 1215 Building a PL/SQL Wrapper 1217 Deleting Files from PL/SQL 1217 Using loadjava 1218 Using dropjava 1221 Managing Java in the Database 1221 The Java Namespace in Oracle 1221 Examining Loaded Java Elements 1222 Using DBMS JAVA 1223 LONGNAME: Converting Java Long Names 1223 GET_, SET_, and RESET_COMPILER_OPTION: Getting and Setting (a Few) Compiler Options 1224 SET_OUTPUT: Enabling Output from Java 1225 EXPORT_SOURCE, EXPORTJtESOURCE, and EXPORT_CLASS: Exporting Schema Objects 1226 Publishing and Using Java in PL/SQL 1228 Call Specs 1228 Some Rules for Call Specs 1229 Mapping Datatypes 1230 Calling a Java Method in SQL 1232 Exception Handling with Java 1232 Extending File I/O Capabilities 1236 Other Examples 1240 28. External Procedures...................1243 Introduction to External Procedures 1244 Example: Invoking an Operating System Command 1244 Architecture of External Procedures 1246 Oracle Net Configuration 1248 Specifying the Listener Configuration 1248 Security Characteristics of the Configuration 1251 Setting Up Multithreaded Mode 1252 Creating an Oracle Library 1254 Writing the Call Specification 1256 The Call Spec: Overall Syntax 1257 Parameter Mapping: The Example Revisited 1258 Parameter Mapping: The Full Story 1260 More Syntax: The PARAMETERS Clause 1262 PARAMETERS Properties 1263 Raising an Exception from the Called C Program 1266 Nondefault Agents 1269 Maintaining External Procedures 1272 Dropping Libraries 1272 Data Dictionary 1272 Rules and Warnings 1273 A. Regular Expression Metacharacters and Function Parameters......................................1275 B. Number Format Models...................1281 C. Date Format Models.......................................................1285 Index...........................1291
any_adam_object	1
author	Feuerstein, Steven Pribyl, Bill
author_facet	Feuerstein, Steven Pribyl, Bill
author_role	aut aut
author_sort	Feuerstein, Steven
author_variant	s f sf b p bp
building	Verbundindex
bvnumber	BV041723411
callnumber-first	Q - Science
callnumber-label	QA76
callnumber-raw	QA76.73.S67
callnumber-search	QA76.73.S67
callnumber-sort	QA 276.73 S67
callnumber-subject	QA - Mathematics
classification_rvk	ST 271
classification_tum	DAT 652f
ctrlnum	(OCoLC)876169190 (DE-599)BVBBV041723411
discipline	Informatik
edition	6. ed.
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03264nam a2200793zc 4500</leader><controlfield tag="001">BV041723411</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20150326 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">140307s2014 cc a\|\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781449324452</subfield><subfield code="9">978-1-449-32445-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)876169190</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV041723411</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">cc</subfield><subfield code="c">CN</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-526</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-91G</subfield><subfield code="a">DE-2174</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.73.S67</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 652f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Feuerstein, Steven</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle PL/SQL programming</subfield><subfield code="b">[covers versions through Oracle database 12c]</subfield><subfield code="c">Steven Feuerstein with Bill Pribyl</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">6. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXVIII, 1340 S.</subfield><subfield code="b">Ill.</subfield><subfield code="c">24 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">PL/SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 8.0</subfield><subfield code="0">(DE-588)4476381-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 12c</subfield><subfield code="0">(DE-588)1045569658</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 11g</subfield><subfield code="0">(DE-588)7601243-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PL/SQL</subfield><subfield code="0">(DE-588)4457669-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 8i</subfield><subfield code="0">(DE-588)4542766-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Personal Computer</subfield><subfield code="0">(DE-588)4115533-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE 12c</subfield><subfield code="0">(DE-588)1045569658</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">PL/SQL</subfield><subfield code="0">(DE-588)4457669-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">ORACLE 8.0</subfield><subfield code="0">(DE-588)4476381-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">PL/SQL</subfield><subfield code="0">(DE-588)4457669-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="3" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" ind2="1"><subfield code="a">Personal Computer</subfield><subfield code="0">(DE-588)4115533-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" ind2=" "><subfield code="8">3\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="4" ind2="0"><subfield code="a">ORACLE 11g</subfield><subfield code="0">(DE-588)7601243-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="4" ind2="1"><subfield code="a">PL/SQL</subfield><subfield code="0">(DE-588)4457669-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="4" ind2=" "><subfield code="8">4\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="5" ind2="0"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="5" ind2=" "><subfield code="8">5\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="6" ind2="0"><subfield code="a">ORACLE 8i</subfield><subfield code="0">(DE-588)4542766-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="6" ind2=" "><subfield code="8">6\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Pribyl, Bill</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027170338&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027170338</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">4\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">5\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">6\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection>
id	DE-604.BV041723411
illustrated	Illustrated
indexdate	2024-07-10T01:03:47Z
institution	BVB
isbn	9781449324452
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-027170338
oclc_num	876169190
open_access_boolean
owner	DE-526 DE-11 DE-91G DE-BY-TUM DE-2174
owner_facet	DE-526 DE-11 DE-91G DE-BY-TUM DE-2174
physical	XXXVIII, 1340 S. Ill. 24 cm
publishDate	2014
publishDateSearch	2014
publishDateSort	2014
publisher	O'Reilly
record_format	marc
spelling	Feuerstein, Steven Verfasser aut Oracle PL/SQL programming [covers versions through Oracle database 12c] Steven Feuerstein with Bill Pribyl 6. ed. Beijing [u.a.] O'Reilly 2014 XXXVIII, 1340 S. Ill. 24 cm txt rdacontent n rdamedia nc rdacarrier Includes index. Oracle (Computer file) PL/SQL (Computer program language) Relational databases ORACLE 8.0 (DE-588)4476381-5 gnd rswk-swf ORACLE 12c (DE-588)1045569658 gnd rswk-swf ORACLE 11g (DE-588)7601243-8 gnd rswk-swf PL/SQL (DE-588)4457669-9 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf ORACLE 9i (DE-588)4646123-1 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf ORACLE 8i (DE-588)4542766-5 gnd rswk-swf Personal Computer (DE-588)4115533-6 gnd rswk-swf ORACLE 12c (DE-588)1045569658 s PL/SQL (DE-588)4457669-9 s DE-604 ORACLE Datenbanksystem (DE-588)4206222-6 s SQL (DE-588)4134010-3 s 1\p DE-604 ORACLE 8.0 (DE-588)4476381-5 s 2\p DE-604 Personal Computer (DE-588)4115533-6 s 3\p DE-604 ORACLE 11g (DE-588)7601243-8 s 4\p DE-604 ORACLE 9i (DE-588)4646123-1 s 5\p DE-604 ORACLE 8i (DE-588)4542766-5 s 6\p DE-604 Pribyl, Bill Verfasser aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027170338&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 3\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 4\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 5\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 6\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk
spellingShingle	Feuerstein, Steven Pribyl, Bill Oracle PL/SQL programming [covers versions through Oracle database 12c] Oracle (Computer file) PL/SQL (Computer program language) Relational databases ORACLE 8.0 (DE-588)4476381-5 gnd ORACLE 12c (DE-588)1045569658 gnd ORACLE 11g (DE-588)7601243-8 gnd PL/SQL (DE-588)4457669-9 gnd SQL (DE-588)4134010-3 gnd ORACLE 9i (DE-588)4646123-1 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE 8i (DE-588)4542766-5 gnd Personal Computer (DE-588)4115533-6 gnd
subject_GND	(DE-588)4476381-5 (DE-588)1045569658 (DE-588)7601243-8 (DE-588)4457669-9 (DE-588)4134010-3 (DE-588)4646123-1 (DE-588)4206222-6 (DE-588)4542766-5 (DE-588)4115533-6
title	Oracle PL/SQL programming [covers versions through Oracle database 12c]
title_auth	Oracle PL/SQL programming [covers versions through Oracle database 12c]
title_exact_search	Oracle PL/SQL programming [covers versions through Oracle database 12c]
title_full	Oracle PL/SQL programming [covers versions through Oracle database 12c] Steven Feuerstein with Bill Pribyl
title_fullStr	Oracle PL/SQL programming [covers versions through Oracle database 12c] Steven Feuerstein with Bill Pribyl
title_full_unstemmed	Oracle PL/SQL programming [covers versions through Oracle database 12c] Steven Feuerstein with Bill Pribyl
title_short	Oracle PL/SQL programming
title_sort	oracle pl sql programming covers versions through oracle database 12c
title_sub	[covers versions through Oracle database 12c]
topic	Oracle (Computer file) PL/SQL (Computer program language) Relational databases ORACLE 8.0 (DE-588)4476381-5 gnd ORACLE 12c (DE-588)1045569658 gnd ORACLE 11g (DE-588)7601243-8 gnd PL/SQL (DE-588)4457669-9 gnd SQL (DE-588)4134010-3 gnd ORACLE 9i (DE-588)4646123-1 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE 8i (DE-588)4542766-5 gnd Personal Computer (DE-588)4115533-6 gnd
topic_facet	Oracle (Computer file) PL/SQL (Computer program language) Relational databases ORACLE 8.0 ORACLE 12c ORACLE 11g PL/SQL SQL ORACLE 9i ORACLE Datenbanksystem ORACLE 8i Personal Computer
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027170338&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT feuersteinsteven oracleplsqlprogrammingcoversversionsthroughoracledatabase12c AT pribylbill oracleplsqlprogrammingcoversversionsthroughoracledatabase12c

Holdings

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Indexes

MARC

Record in the Search Index

There is no print copy available.

Similar Items