Oracle SQL: Jumpstart with Examples

Oracle SQL: Jumpstart with Examples
ISBN-10
0080479839
ISBN-13
9780080479835
Category
Computers
Pages
688
Language
English
Published
2004-10-15
Publisher
Elsevier
Authors
Carol McCullough-Dieter, Gavin JT Powell

Description

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

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Mastering Oracle SQL
    Mastering Oracle SQL
    By Alan Beaulieu, Sanjay Mishra

    Explores Oracle's implementation of SQL and explains how to perform tasks including querying time-based data, implementing conditional logic in queries, writing queries, and joining data from two or more tables.

  • Beginning Oracle SQL: For Oracle Database 12c
    Beginning Oracle SQL: For Oracle Database 12c
    By Tim Gorman, Melanie Caffrey, Lex deHaan

    Comparing Views, Tables, and Materialized Views SQL> create or replace VIEW dept20_v as 2 select * from employees where deptno = 20; View created. SQL> create TABLE dept20_t as 2 select * from employees where deptno = 20; Table created.

  • Mastering Oracle SQL: Putting Oracle SQL to Work
    Mastering Oracle SQL: Putting Oracle SQL to Work
    By Alan Beaulieu, Sanjay Mishra

    Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering ...

  • Oracle PL/SQL Programming
    Oracle PL/SQL Programming
    By Steven Feuerstein, Bill Pribyl

    If you're working with multibyte character sets , it matters which function you use in any given situation . When using Unicode , you have even more character function variations to learn about . Code points and code ...

  • Practical Oracle SQL: Mastering the Full Power of Oracle Database
    Practical Oracle SQL: Mastering the Full Power of Oracle Database
    By Kim Berg Hansen

    If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as: Pivoting rows to columns and columns to rows Recursion in SQL with MODEL and WITH ...

  • Practical Oracle SQL: Mastering the Full Power of Oracle Database
    Practical Oracle SQL: Mastering the Full Power of Oracle Database
    By Kim Berg Hansen

    If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:Pivoting rows to columns and columns to rowsRecursion in SQL with MODEL and WITH ...

  • Oracle SQL Revealed: Executing Business Logic in the Database Engine
    Oracle SQL Revealed: Executing Business Logic in the Database Engine
    By Alex Reprintsev

    This book covers features that are often not well known, and sometimes not implemented in competing products.

  • Oracle PL / SQL For Dummies
    Oracle PL / SQL For Dummies
    By Paul Dorsey, Michael Rosenblum

    Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless!

  • Pro Oracle SQL
    Pro Oracle SQL
    By Karen Morton, Robyn Sands, Jared Still

    Sullivan,Rue 1998 Peripherals and Accessories $259.90 Sullivan,Rue 1998 Software/Other $19.59 Sullivan,Rue 2000 Electronics $2,213.30 Sullivan,Rue 2000 Hardware $1,359.06 Sullivan,Rue 2000 Peripherals and Accessories $1,169.94 Sullivan ...

  • Oracle PL/SQL Best Practices: Optimizing Oracle Code
    Oracle PL/SQL Best Practices: Optimizing Oracle Code
    By Steven Feuerstein

    In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules ...