Oracle Database 12c PL/SQL Programming
Nonfiction, Computers, Database Management, Application Software, Business Software, Programming
| Author: | Michael McLaughlin | ISBN: | 9780071812443 |
| Publisher: | McGraw-Hill Education | Publication: | February 7, 2014 |
| Imprint: | McGraw-Hill Education | Language: | English |
| Author: | Michael McLaughlin |
| ISBN: | 9780071812443 |
| Publisher: | McGraw-Hill Education |
| Publication: | February 7, 2014 |
| Imprint: | McGraw-Hill Education |
| Language: | English |
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
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
