Oracle Database 12C SQL

by Price

About the Book: Oracle Database 12c SQL Oracle Database 12c SQL explains how to write powerful SQL statements and PL/SQL programs using Oracles latest core Database 12c. This Oracle Press guide shows readers how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. In-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML is included. Carefully revised to let readers explore SQL Plus, SQL Developer, and more Reveals best practices for writing PL/SQL scripts Code and examples available online Teaches new and experienced developers the best ways to write Java programs to access an Oracle database using JDBC Contents: 1 Introduction 2 Retrieving Information from Database Tables 3 Using SQL Plus 4 Using Simple Functions 5 Storing and Processing Dates and Times 6 Subqueries 7 Advanced Queries 8 Analyzing Data 9 Changing Table Contents 10 Users, Privileges, and Roles 11 Creating Tables, Sequences, Indexes, and Views 12 Introducing PL/SQL Programming 13 Database Objects 14 Collections 15 Large Objects 16 SQL Tuning 17 XML and the Oracle Database A Oracle Data Types Index About the Author: Price Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of Oracles products and is an Oracle Certified Database Administrator and Application Developer. Price is the author of books on C#, Java programming, and Oracle Databases.

Genres: Programming

684 pages, Paperback

First published January 1, 2013

Reviews

[AbdAllah · Rating 4 out of 5]

Great for beginners.

[Przemek · Rating 4 out of 5]

Książka bardzo dobra. Taka w miarę obszerna dokumentacja. Polecam.

[Hhh · Rating 5 out of 5]

good