Oracle Database 12c PL/SQL Programming

  • 16h 11m
  • Michael McLaughlin
  • Oracle Press
  • 2014

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.

  • Explore new SQL and PL/SQL features in Oracle Database 12c
  • Build control structures, cursors, and loop statements
  • Work with collections, varrays, tables, and associative array collections
  • Locate and repair errors and employ exception handlers
  • Execute black box, white box, and integration tests
  • Configure and manage stored packages and libraries
  • Handle security with authentication and encryption
  • Use LOBs to store text and multimedia content
  • Write and implement PL/SQL and Java triggers
  • Extend functionality using dynamic SQL statements
  • Understand object types, nested tables, and unnesting queries

About the Author

Michael McLaughlin, Oracle ACE , is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT Management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g & MySQL 5.6 Developer Handbook, Oracle Database 11g PL/SQL Programming Workbook, and many other books. Mr. McLaughlin worked at Oracle Corporation for more than eight years in Consulting, Development and Support. He left Oracle as the Senior Applications Upgrade Manager in E-Business Suite Release Engineering.

In this Book

  • Oracle Database 12c PL/SQL Programming
  • Introduction
  • Oracle PL/SQL Development Overview
  • New Features
  • PL/SQL Basics
  • Language Fundamentals
  • Control Structures
  • Collections
  • Error Management
  • Functions and Procedures
  • Packages
  • Large Objects
  • Object Types
  • Triggers
  • Dynamic SQL
  • Oracle Database Primer
  • SQL Primer
  • SQL Built-in Functions
  • PL/SQL Built-in Packages and Types
  • Regular Expression Primer
  • Wrapping PL/SQL Code Primer
  • PL/SQL Hierarchical Profiler Primer
  • PL/SQL Reserved Words and Keywords
  • Mastery Check Answers
  • Glossary
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book Java Persistence with NoSQL: Revolutionize Your Java Apps with NoSQL Integration

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Agile Software Projects: Estimation Methods
Rating 4.4 of 176 users Rating 4.4 of 176 users (176)
Book Introduction to SQL and PL/SQL
Book Mastering Oracle PL/SQL: Practical Solutions