Contents note continued: POWERMULTLSET_BY_CARDINALITY Function -- Set Function -- Collection Set Operators -- CARDINALITY Operator -- EMPTY Operator -- MULTISET Operator -- MULTISET EXCEPT Operator -- MULTISET Intersect Operator -- MULTISET Union Operator -- SET Operator -- SUBMULTISET OF Operator -
Oracle Database 12c PL/SQL Programming
โ Scribed by McLaughlin, Michael J
- Publisher
- McGraw-Hill Education
- Year
- 2014;2013
- Tongue
- English
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
"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"--;"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"--
โฆ Table of Contents
Updated TOC to FollowPart I: PL/SQL FundamentalsChapter 1. Oracle PL/SQL OverviewChapter 2. PL/SQL BasicsChapter 3. Language FundamentalsChapter 4. Control StructuresChapter 5. Error ManagementPart II: PL/SQL ProgrammingChapter 6. Functions and ProceduresChapter 7. CollectionsChapter 8. Large ObjectsChapter 9. PackagesChapter 10. TriggersPart III: PL/SQL Advanced ProgrammingChapter 11. Dynamic SQLChapter 12. Intersession CommunicationChapter 13. External ProceduresChapter 14. Object TypesChapter 15. Java LibrariesChapter 16. Web Application DevelopmentPart IV: AppendixesAppendix A. Oracle Database Administration PrimerAppendix B. Oracle Database SQL PrimerAppendix C. PHP PrimerAppendix D. Oracle Database Java PrimerAppendix E. Regular Expression PrimerAppendix F. Wrapping PL/SQL Code PrimerAppendix G. PL/SQL Hierarchical Profiler PrimerAppendix H. PL/ScopeAppendix I. PL/SQL Reserved Words and KeywordsAppendix J. PL/SQL Built-in FunctionsIndex
โฆ Subjects
Computer Science;COMPUTERS--Database Management--General;Database design;Database management;Debugging in computer science;Engineering & Applied Sciences;PL/SQL (Computer program language);Electronic books;Oracle (Computer file);COMPUTERS -- Database Management -- General
๐ SIMILAR VOLUMES
Master Oracle Database 12c PL/SQL Application Development<br>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, exe
<h4>Master Oracle Database 12<i>c</i> PL/SQL Application Development</h4> <p>Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, <i>Oracle Database 12c PL/SQL Programming</i> explains how to retrieve and process data, write