Zum Hauptinhalt springen Zur Suche springen Zur Hauptnavigation springen
Beschreibung
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.
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.
Über den Autor
Jason Price (Castro Valley, CA) has over 10 years experience in the software industry, 5 of which were spent at Oracle. Jason is an Oracle Certified Professional DBA and Application Developer and has written several books: Java Programming with Oracle SQLJ, O'Reilly (2001) Oracle9i JDBC Programming, Oracle Press (2002) Mastering Visual C# .NET, Sybex (2002) Mastering Visual C# .NET Database Programming, Sybex (2003.
Inhaltsverzeichnis

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

Details
Erscheinungsjahr: 2013
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780071799355
ISBN-10: 0071799354
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Price, Jason
Hersteller: McGraw-Hill Education
Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de
Maße: 235 x 191 x 37 mm
Von/Mit: Jason Price
Erscheinungsdatum: 10.09.2013
Gewicht: 1,266 kg
Artikel-ID: 106093472