02720nam a2200289 a 4500 1/45135 140729s2005 ne 001 0 eng 9781555583231 1555583237 48093 OPELS eng OPELS BAKER OKU OCLCQ OCLCF GR-PeUP Powell, Gavin. Oracle SQL [electronic resource] : jumpstart with examples / Gavin Powell, Carol McCullough-Dieter. Amsterdam ; Boston : Elsevier Digital Press, c2005. 1 online resource (xxix, 652 p.) : ill. Includes bibliographical references and index. Introduction to Oracle SQL -- New features of Oracle SQL -- Oracle database architecture -- The SELECT statement -- Filtering rows -- Sorting rows -- Operators, conditions, and pseudocolumns -- Using SQL*Plus -- Single-row functions -- Joining tables -- Grouping and summarizing data -- Subqueries -- Unusual query types -- Expressions -- Data manipulation language (DML) -- Datatypes and collections -- XML in Oracle -- Tables -- Views -- Constraints -- Indexes and clusters -- Sequences and synonyms -- Security -- Basic PL/SQL. Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL. * Each of the hundreds of SQL code examples was tested on a working Oracle 10g database * Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code * Authors have four decades of commercial experience between them as developers and database administrators. Oracle (Computer file) SQL (Computer program language). Relational databases. Electronic books. McCullough-Dieter, Carol. INST UNIPILB EBOOKS 20140729 00b48093 00b48093 ONLINE 0 ScienceDirect http://www.sciencedirect.com/science/book/9781555583231 /webopac/covers/03/48093_9781555583231.jpg /webopac/covers/03/48093_1555583237.jpg