Oracle Database 12c PL/SQL Programming

Michael McLaughlin

Informasi Umum

Kode

16.01.688

Klasifikasi

005.758 5 - Specific distributed database management systems

Jenis

Buku - Circulation (Dapat Dipinjam)

Subjek

Oracle, Pl/sql, Database Design, Database Management,

No. Rak

Tel-U Purwokerto : Rak 2

Dilihat

103 kali

Informasi Lainnya

Abstraksi

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