John M. Harper – författare
805 kr
Läs direkt efter köp
Ramp Up Your PL/SQL Programming Skills
Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.
Understand the Oracle development architecture and the mechanics of connectionsWork with data types, structures, blocks, cursors, and PL/SQL semanticsWrite, deploy, and use functions, procedures, and packagesManage transactions and moreUse dynamic SQL statements in real-world applicationsSupport online transaction processing and data warehousing applications with external tablesFind syntax samples and best practices to solve problemsWrite, deploy, and use object typesFor a complete list of Oracle Press titles, visit www.OraclePressBooks.com
1 112 kr
Läs direkt efter köp
Take Your PL/SQL Programming Skills to the Next Level
Build robust database-centric PL/SQL applications quickly and effectively. Oracle Database 12c PL/SQL Advanced Programming Techniques shows you how to write and deploy Java libraries inside Oracle Database 12c, use the utl_file and DBMS_SCHEDULER packages, and create external tables and external procedures. Application security, performance tuning, and Oracle Database In-Memory are also covered in this Oracle Press guide.
Configure, deploy, and troubleshoot Java libraries for Oracle object typesUse the utl_file package to manage unstructured and structured dataDevelop and deploy Java I/O libraries and wrap them with PL/SQLCreate and use external tablesImplement high-speed data transferHarden database systems and develop secure applicationsManage complex schedules and jobs with the DBMS_SCHEDULER packageOptimize PL/SQL for use in performance tuningCreate and deploy external proceduresImplement the Oracle Database In-Memory column store feature