Write Powerful SQL Statements and PL/SQL Programs
Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out 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 contains everything you need to know to master SQL.
Use SQL statements to access 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 handle abstract data
Use date, time stamp, and time interval data types
Establish user roles and privileges
Handle multimedia files using large objects
Tune SQL statements to make them execute faster
Generate, process, and store XML data
Master the very latest Oracle Database 12c features
Code examples in the book are available for download.
Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of Oracle's products and is an Oracle Certified Database Administrator and Application Developer. Price is the author of books on C#, Java programming, and Oracle Databases.
Keywords: SQL, ORACLE, ORACLE PRESS, ORACLE DATABASE 12C, PL/SQL, PROGRAMS, PROGRAMMING, RETRIEVE, MODIFY, DATABASE, INFORMATION, SQL PLUS, SQL DEVELOPER, DATABASE OBJECTS, PERFORMANCE OPTIMIZATION, ADVANCED QUERIES, JAVA, XML, BEST PRACTICES, CODE, JDBC, DBA, STATEMENT, JASON PRICE, ORACLE JDEVELOPER 11G HANDBOOK, ORACLE JDEVELOPER 10G FOR FORMS & PL/SQL DEVELOPERS, ORACLE DATABASE 10G EXPRESS EDITION PHP WEB PROGRAMMING, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G SQL, ORACLE DATABASE AJAX & PHP WEB APPLICATION DEVELOPMENT, ORACLE SQL DEVELOPER HANDBOOK, ORACLE APPLICATION SERVER 10G WEB DEVELOPMENT, ORACLE HTML DB HANDBOOK, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, ORACLE DATABASE 11G AND MYSQL 5.5 DEVELOPER HANDBOOK, JAVA 7 PROGRAMMING, JAVA SE 7 PROGRAMMER STUDY GUIDE, EFFECTIVE MYSQL BACKUP AND RECOVERY, EFFECTIVE MYSQL OPTIMIZING SQL STATEMENTS, EFFECTIVE MYSQL ADVANCED REPLICATION TECHNIQUES, MYSQL WORKBENCH DATA MODELING AND DEVELOPMENT, ORACLE DATABASE 11G THE COMPLETE REFERENCE, ORACLE DATABASE 11G A BEGINNER'S GUIDE, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G NEW FEATURES, ORACLE DATABASE 11G DBA HANDBOOK, ORACLE DATABASE 11G SQL, OCA ORACLE DATABASE 11G ADMINISTRATION I EXAM GUIDE, OCA ORACLE DATABASE 11G SQL FUNDAMENTALS I EXAM GUIDE, OCP ORACLE DATABASE 11G NEW FEATURES FOR ADMINISTRATORS EXAM GUIDE, OCP ORACLE DATABASE 11G ADMINISTRATION II EXAM GUIDE, ORACLE DATABASE 11G RMAN BACKUP & RECOVERY, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, OCA/OCP ORACLE DATABASE 11G ALL-IN-ONE EXAM GUIDE, MICROSOFT SQL SERVER 2008 ADMINISTRATION FOR ORACLE DBAS, ORACLE DATABASE ADMINISTRATION FOR SQL SERVER DBAS, ORACLE STREAMS 11G DATA REPLICATION, ORACLE DATABASE 11G RELEASE 2 HIGH AVAILABILITY, MAXIMIZE YOUR AVAILABILITY WITH GRID INFRASTRUCTURE, RAC AND DATA GUARD, ORACLE REAL APPLICATION CLUSTERS TESTING AND TUNING, OCP, EFFECTIVE MYSQL BACKUP AND RECOVERY, EFFECTIVE MYSQL OPTIMIZING SQL STATEMENTS, ORACLE DATABASE 11G PERFORMANCE TUNING TIPS AND TECHNIQUES, ORACLE SOLARIS 11 SYSTEM ADMINISTRATION THE COMPLETE REFERENCE