Definitive Guide : Definitive Guide - Jonathan Gennick

Instant online reading.
Don't wait for delivery!

Definitive Guide

By: Jonathan Gennick

Write A Review

Paperback | 7 December 2004 | Edition Number 2

At a Glance

Paperback
560 Pages

Dimensions(cm)
23.5 x 17.78 x 3.18

Paperback

RRP $75.95

$39.75

48%OFF

or 4 interest-free payments of $9.94 with

Ships in 15 to 25 business days

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly:

write and execute script files
generate ad hoc reports
extract data from the database
query the data dictionary tables
customize an SQLPlus environment
and much more

It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Databases Database Software Oracle Computer Science Systems Analysis & Design Operating Systems Data Mining Booktopia Publisher Services

John Wiley & Sons Publishers UK Data Warehousing

Preface
Introduction to SQL
Plus What Is SQL
Plus? History of SQL
Plus Why Master SQL
Plus? Creating and Loading the Sample Tables
Command-Line SQL
Plus Starting Command-Line SQL
Plus Starting Windows SQL
Plus Some Basic SQL
Plus Commands Running SQL Queries Working With PL/SQL The SQL Buffer Line Editing Executing the Statement in the Buffer Saving and Retrieving the Buffer The EDIT Command Executing a Script The Working Directory
Browser-Based SQL
Plus Starting iSQL
Plus Executing SQL
Plus Commands Running SQL Queries Working with PL/SQL Executing Scripts iSQL
Plus Command History
A Lightning SQL Tutorial Data Manipulation Statements Transactions The Concept of Null Table Joins Sorting Query Results Grouping and Summarizing Subqueries Unions To Learn More
Generating Reports with SQL
Plus Following a Methodology Saving Your Work Designing a Simple Report Master/Detail Reports
Creating HTML Reports Getting the Data into an HTML Table Generating the Entire Page Another Approach to Headers Master/Detail Reports in HTML
Advanced Reports Totals and Subtotals Getting the Current Date into a Header Report Headers and Footers Formatting Object Columns Summary Reports Taking Advantage of Unions
Writing SQL
Plus Scripts Why Write Scripts? Using Substitution Variables Prompting for Values Cleaning Up the Display Executing a Script Controlling Variable Substitution Commenting Your Scripts Resetting Your SQL
Plus Environment Scripting Issues with iSQL
Plus
Extracting and Loading Data Types of Output Files Limitations of SQL
Plus Extracting the Data An Excel-Specific HTML Hack Reloading the Data
Exploring Your Database The DESCRIBE Command Oracle's Data Dictionary Views Tables Table Constraints Indexes Triggers Synonyms Table Security Scripting the Data Dictionary Using SQL to Write SQL The Master Key
Advanced Scripting Bind Variables Branching in SQL
Plus Looping in SQL
Plus Validating and Parsing User Input Error Handling Returning Values to Unix
Tuning and Timing Using SQL
Plus Timers Using EXPLAIN PLANstatements Using AUTOTRACE Improving on EXPLAIN PLAN Results Where to Find More Tuning Information
The Product User Profile What Is the Product User Profile? Using the Product User Profile
Customizing Your SQL
Plus Environment SQL
Plus Settings You Can Control The Site and User Profiles Environment Variables That Affect SQL
Plus Windows GUI SQL
Plus iSQL
Plus User Preferences A. SQL
Plus Command Reference B. SQL
Plus Format Elements
Index
Table of Contents provided by Publisher. All Rights Reserved.

Definitive Guide

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Statistics and Data Handling for Biologists

A Student's Guide

Statistics and Data Handling for Biologists

A Student's Guide

Ethics and Governance of Artificial Intelligence

Frameworks, Risks, and Society

ESG Investment, German Industrie 4.0, and Blockchain

From Data to Dollars

Getting Started with Data Analytics and AI in Startups

Digital Outcasts

Moving Technology Forward without Leaving People Behind

Python All-in-One For Dummies

3rd Edition

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Hands-On Programming with R

Write Your Own Functions and Simulations

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Microsoft 365 Access For Dummies

Access for Dummies

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

The Value of People Analytics

Using HR Data to Drive Business Results

R for Data Science

Import, Tidy, Transform, Visualize, and Model Data

Microsoft Power Bi Data Analyst Associate Study Guide

Prepare for the Pl-300 Exam and Apply Best Practice Design

Python for Excel

A Modern Environment for Automation and Data Analysis

Artificial Intelligence for HR

Use AI to Support and Develop a Successful Workforce

Learning Data Science

Data Wrangling, Exploration, Visualization, and Modeling with Python

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Building a Scalable Data Warehouse with Data Vault 2.0

Social Research Methods

4th Edition

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

This product is categorised by