Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

5.0 4
by Michael McLaughlin
     
 

View All Available Formats & Editions

Master Oracle Database 12c PL/SQL Application Development

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

See more details below

Overview

Master Oracle Database 12c PL/SQL Application Development

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

Read More

Product Details

ISBN-13:
9780071812436
Publisher:
McGraw-Hill Professional Publishing
Publication date:
02/07/2014
Pages:
1192
Sales rank:
670,208
Product dimensions:
7.30(w) x 9.10(h) x 2.10(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >