Oracle 11g Sql
Download Oracle 11g Sql PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Oracle 11g Sql book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
Oracle 11G: SQL
ORACLE 11G: SQL is an introduction to the fundamental SQL language used in all relational databases today. This textbook is not simply a study guide; it is written for those who have just a basic knowledge of databases and can be used in a course on this latest implementation of SQL from Oracle. Learning these concepts and techniques prepares students for the first exam in both the Oracle Database Administrator and Oracle Developer Certification Exam paths and offers a solid understanding of using Oracle 11g SQL effectively. The first part of ORACLE 11G: SQL focuses on creating database objects, including tables, constraints, indexes, sequences, synonyms, and users, and manipulating data. The second part explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views. Several advanced query topics, such as ROLLUP, CUBE, and TOP-N analysis, are also introduced. To help students bridge these SQL topics to further studies, appendixes introduce SQL tuning, compare Oracle’s SQL syntax with other databases (MS SQL Server and MySQL), and explain how to embed SQL in applications (ASP.NET). An overview of the two Oracle connection interface tools, SQL Developer and SQL Plus, is also provided. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Oracle Database 11g PL/SQL Programming
Author: Michael McLaughlin
language: en
Publisher: McGraw Hill Professional
Release Date: 2008-04-19
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit
Oracle Database 11g PL/SQL Programming Workbook
Author: Michael McLaughlin
language: en
Publisher: McGraw Hill Professional
Release Date: 2010-02-10
Ramp Up Your PL/SQL Programming Skills Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com