Oracle Database 12c SQL

Jason Price

ISBN 10: 0071799354 / ISBN 13: 9780071799355

Editore: The McGraw-Hill Company, 2013

Riguardo questo articolo

pp. 544.

Codice articolo 96422895

Dati bibliografici

• Titolo: Oracle Database 12c SQL
• Editore: The McGraw-Hill Company
• Data di pubblicazione: 2013
• Lingua: Inglese
• ISBN 10: 0071799354
• ISBN 13: 9780071799355
• Rilegatura: Brossura
• Condizione: New

Descrizione articolo

Riassunto

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

Informazioni sull?autore

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.