Description
Write Powerful SQL Statements and PL/SQL Programs
Learn how to get right of entry to Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the recent database features and techniques. Learn how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide accommodates the whole thing you want to know to master SQL.
- Use SQL statements to get right of entry to an Oracle database
- Work with SQL*Plus and SQL Developer
- Write PL/SQL programs
- Create tables, sequences, indexes, views, and triggers
- Design advanced queries containing complex calculations
- Create database objects to deal with abstract data
- Use date, time stamp, and time interval data types
- Establish user roles and privileges
- Handle multimedia files the use of large objects
- Tune SQL statements to cause them to execute faster
- Generate, process, and store XML data
- Master the very recent Oracle Database 12c features
Code examples in the book are to be had for download.