Oracle Database 12c PL/SQL programming
(eBook)
Author
Published
New York : McGraw-Hill Education, ©2014.
Format
eBook
ISBN
007181244X, 9780071812443
Physical Desc
1 online resource (xxxiii, 1154 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
Includes index.
Description
"A complete update of the essential desktop reference for PL/SQL, rewritten and expanded by to highlight the massive changes in Oracle Database 12c. Written by an Oracle ACE, Oracle Database 12c PL/SQL Programming offers in-depth information on the entire PL/SQL language and its extensibility to develop applications. With full coverage of the latest features and tools, this Oracle Press guide provides examples of web applications in native PL/SQL, JSP, and PHP. The book explains how to access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy security. A Netflix case study example is used throughout the book as the basis for all coding examples. This enables application design consideration, data types, structures, and coding approaches to build an integrated view of the PL/SQL programming language. The examples collectively provide you with both a reference to how various programming concepts work and how components fit together to solve real-world problems"--,Provided by publisher
Description
"Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide"--,Provided by publisher
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
McLaughlin, M. (2014). Oracle Database 12c PL/SQL programming . McGraw-Hill Education.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)McLaughlin, Michael. 2014. Oracle Database 12c PL/SQL Programming. McGraw-Hill Education.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)McLaughlin, Michael. Oracle Database 12c PL/SQL Programming McGraw-Hill Education, 2014.
MLA Citation, 9th Edition (style guide)McLaughlin, Michael. Oracle Database 12c PL/SQL Programming McGraw-Hill Education, 2014.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
45d8009f-8029-8181-4360-46345610dd8d-eng
Grouping Information
| Grouped Work ID | 45d8009f-8029-8181-4360-46345610dd8d-eng |
|---|---|
| Full title | oracle database 12c pl sql programming |
| Author | mclaughlin michael |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 03:07:49AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Sep 30, 2024 |
| Last Used | Sep 30, 2024 |
Marc Record
| First Detected | Jul 29, 2024 04:00:38 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:34:38 PM |
MARC Record
| LEADER | 06912cam a2200553 a 4500 | ||
|---|---|---|---|
| 001 | ocn871683734 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 140307s2014 nyua o 001 0 eng d | ||
| 019 | |a 1164488982|a 1425950037 | ||
| 020 | |a 007181244X|q (electronic bk.) | ||
| 020 | |a 9780071812443|q (electronic bk.) | ||
| 020 | |z 0071812431 | ||
| 020 | |z 007181244X | ||
| 020 | |z 9780071812436 | ||
| 035 | |a (OCoLC)871683734|z (OCoLC)1164488982|z (OCoLC)1425950037 | ||
| 037 | |a 9D146B05-8167-4F17-BA39-1C05EB163618|b OverDrive, Inc.|n http://www.overdrive.com | ||
| 037 | |a CL0500000395|b Safari Books Online | ||
| 040 | |a UMI|b eng|e pn|c UMI|d S4S|d COO|d B24X7|d DEBBG|d DEBSZ|d TEFOD|d YDXCP|d OCLCF|d OCLCQ|d TEFOD|d OCLCQ|d TOH|d RDF|d EBLCP|d OCLCO|d OCLCQ|d OCLCO|d OCLCL|d N$T | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.75/85|2 23 |
| 100 | 1 | |a McLaughlin, Michael|q (Michael J.)|1 https://id.oclc.org/worldcat/entity/E39PCjBQwmCqPDGxr688wXdQmd|0 http://id.loc.gov/authorities/names/no2005009408 | |
| 245 | 1 | 0 | |a Oracle Database 12c PL/SQL programming /|c Michael McLaughlin. |
| 260 | |a New York :|b McGraw-Hill Education,|c ©2014. | ||
| 300 | |a 1 online resource (xxxiii, 1154 pages) :|b illustrations | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover -- Title Page -- Copyright Page -- About the Author -- About the Contributing Author -- About the Technical Editor -- Contents at a Glance -- Contents -- Acknowledgments -- Introduction -- Book Outline -- Part I: PL/SQL Fundamentals -- Part II: PL/SQL Programming -- Part III: Appendixes and Glossary -- Lexicon -- SQL Lexicon -- PL/SQL Stored Programs -- Other Conventions -- Data Model and Source Code to Download -- Part I: Oracle PL/SQL -- Chapter 1: Oracle PL/SQL Development Overview -- PL/SQL's History and Background -- Oracle Development Architecture -- The Database | |
| 505 | 8 | |a The PL/SQL Language -- The Oracle Processing Architecture -- Two-Tier Model -- N-Tier Model -- Summary -- Mastery Check -- Chapter 2: New Features -- New SQL Features -- Data Catalog DIRECTORY Qualifies a LIBRARY Object -- Define Tables with Valid-Time (VT) Support -- Table with Explicit VT Columns -- Table with Implicit VT Columns -- Enhanced Oracle Native LEFT OUTER JOIN Syntax -- Default Values for Columns Based on Sequences -- Default Values for Explicit Null Insertion -- Identity Columns -- Increased Size Limits of String and Raw Types -- Pass Results from SQL Statements to External Programs | |
| 505 | 8 | |a Native SQL Support for Query Row Limits and Offsets -- Oracle Database Driver for MySQL Applications -- SQL CROSS APPLY, OUTER APPLY, and LATERAL -- Bequeath CURRENT_USER Views -- New PL/SQL Features -- Caching of Invoker Rights Functions -- Ability to White List PL/SQL Program Unit Callers -- Native Client API Support for PL/SQL Types -- New PL/SQL Package UTL_CALL_STACK -- DBMS_UTILITY Adds EXPAND_SQL_TEXT Subprogram -- DBMS_SQL Adds a New Formal Schema to the PARSE Procedure -- PL/SQL Functions in SQL WITH Clause -- PL/SQL-Specific Data Types Allowed in SQL | |
| 505 | 8 | |a Implicit REF CURSOR Parameter Binding -- Supporting Scripts -- Summary -- Mastery Check -- Chapter 3: PL/SQL Basics -- Block Structure -- Execution Block -- Basic Block Structure -- Declaration Block -- Exception Block -- Behavior of Variables in Blocks -- Anonymous Blocks -- Nested Anonymous Blocks -- Local Named Blocks -- Stored Named Blocks -- Basic Scalar and Composite Data Types -- Scalar Data Types -- Strings -- Dates -- Numbers -- Attribute and Table Anchoring -- Composite Data Types -- SQL UDT -- PL/SQL Record Type -- SQL Collection -- PL/SQL Collection -- Control Structures | |
| 505 | 8 | |a Conditional Structures -- If, Elsif, and Else Statements -- CASE Statement -- Iterative Structures -- For Loop Statements -- While Loop Statements -- Simple Loop Statements -- Exceptions -- User-Defined Exceptions -- Dynamic User-Defined Exceptions -- Bulk Operations -- Functions, Procedures, and Packages -- Functions -- Procedures -- Packages -- Transaction Scope -- Single Transaction Scope -- Multiple Transaction Scopes -- Database Triggers -- Summary -- Mastery Check -- Chapter 4: Language Fundamentals -- Lexical Units -- Delimiters -- Identifiers -- Reserved Words and Keywords | |
| 520 | 2 | |a "A complete update of the essential desktop reference for PL/SQL, rewritten and expanded by to highlight the massive changes in Oracle Database 12c. Written by an Oracle ACE, Oracle Database 12c PL/SQL Programming offers in-depth information on the entire PL/SQL language and its extensibility to develop applications. With full coverage of the latest features and tools, this Oracle Press guide provides examples of web applications in native PL/SQL, JSP, and PHP. The book explains how to access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy security. A Netflix case study example is used throughout the book as the basis for all coding examples. This enables application design consideration, data types, structures, and coding approaches to build an integrated view of the PL/SQL programming language. The examples collectively provide you with both a reference to how various programming concepts work and how components fit together to solve real-world problems"--|c Provided by publisher | |
| 520 | 2 | |a "Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide"--|c Provided by publisher | |
| 588 | 0 | |a Print version record. | |
| 630 | 0 | 0 | |a Oracle (Computer file)|0 http://id.loc.gov/authorities/names/n91015760 |
| 630 | 0 | 7 | |a Oracle (Computer file)|2 fast |
| 650 | 0 | |a PL/SQL (Computer program language)|0 http://id.loc.gov/authorities/subjects/sh96008008 | |
| 650 | 0 | |a Database design.|0 http://id.loc.gov/authorities/subjects/sh88004472 | |
| 650 | 0 | |a Database management.|0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Debugging in computer science.|0 http://id.loc.gov/authorities/subjects/sh85036145 | |
| 758 | |i has work:|a Oracle Database 12c PL/SQL programming (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGkGVTY68dyhR4k6r9Yr7b|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version:|a McLaughlin, Michael.|t Oracle Database 12c PL/SQL programming.|d New York : McGraw-Hill Education, 2014|z 9780071812436|w (OCoLC)867769854 |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |