carnevalemanfredonia.it
» » Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

eBook Oracle SQL*Plus: The Definitive Guide (Definitive Guides) download

by Jonathan Gennick

eBook Oracle SQL*Plus: The Definitive Guide (Definitive Guides) download ISBN: 0596007469
Author: Jonathan Gennick
Publisher: O'Reilly Media; Second edition (November 26, 2004)
Language: English
Pages: 586
ePub: 1251 kb
Fb2: 1417 kb
Rating: 4.4
Other formats: mobi azw mobi doc
Category: Technologies
Subcategory: Computer Science

Oracle SQL Plus: The Defnitive Guide. Jonathan Gennick and co did a good job here

Oracle SQL Plus: The Defnitive Guide. This book is great for those using the SQL Plus tool. Jonathan Gennick and co did a good job here. This "Oracle SQL Plus: The Definitive Guide" would be appreciated by most users, although that advanced SQL users who thirst for a unique guidance, having understood the elementary basics of SQL are its primary target.

Authors: Jonathan Gennick. Introducing Microsoft Office InfoPath 2003 (Bpg-Other). Oracle SQL Loader: The Definitive Guide. Oracle SQL Plus Pocket Reference (Pocket Reference (O'Reilly)). Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide). Beginning Cryptography with Java.

The Definitive Guide. Having SQL Plus generate the entire HTML page is possible. Chapter 6. Creating HTML Reports. Beginning with Oracle8i Database Release 2 (Version . 6), you can use SQL Plus to generate HTML pages. Instead of spooling a report to a printer, you can write it to an HTML file for viewing on your corporate intranet.

This book is the definitive guide to SQL Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQLPlus is an interactive query tool that is ubiquitous in the Oracle world. SQLPlus has been shipp/ SQLPlus This book is the definitive guide to SQL Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book

series Definitive Guides. This bestselling book-now updated for Oracle 10g-is the only in-depth guide to this interactive query tool for writing SQL scripts.

series Definitive Guides. It's an essential resource for any Oracle user. With Oracle SQLPlus: The Definitive Guide, you'll expertly

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL Plus.

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL Plus.

ORACLE SQL PLUS DEFINITIVE GUIDE O'Reilly JONATHAN GENNICK Database Book 1999. Definitive Guides: Oracle SQL Plus by Jonathan Gennick (2004, Paperback). Oracle SQL Plus by Gennick, Jonathan. Pocket Reference (o'Reilly): Oracle SQL Plus by Jonathan Gennick (2004

This book is the definitive guide to SQLPlus. SQL-Plus is a fundamental tool but it is hard to find a useful guide on the topic in the market. And I am glad finally there is on. racle Sql Plus: The Definitive Guide is really interesting to read

This book is the definitive guide to SQLPlus. racle Sql Plus: The Definitive Guide is really interesting to read.

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 filesgenerate ad hoc reportsextract data from the databasequery the data dictionary tablescustomize an SQLPlus environmentand much moreIt 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.
Comments: (7)
GODMAX
I enjoyed this book. It described features of SQL Plus that I did not even know it had. I go to this book when there is something in SQL Plus that I was not sure about (setting or parm) and I am always able to find the answer.
Dorintrius
A must have if you do any kind of queries with Oracle.
????????????????????????
It has been very useful...
Gaxaisvem
Oracle SQL Plus: The Defnitive Guide

Jonthan Gennick

1-56592-578-5

This book is great for those using the SQL Plus tool. I use SQL Plus for Oracle 8 and 9. This book covers up to 8i but I have not had any trouble using the commands in 9i. I have not tried the commands listed on 10g yet. The book is easy to use since the topics are split into reasonable chapters and the font is large enough to read with the book beside the keyboard. I also like the chapters that list commonly used items in tables. One example would be the chapter listing the user_ and all_ views. The chapter covering the SET command is one I use frequently. This book is fairly specific to the usage of SQL Plus itself and does not delve too deeply into the inner workings of the Oracle database, but it does have examples in SQL query language and PL/SQL stored procedures. If one is looking for a book on SQL itself, I recommend another title. If one needs a book on SQL Plus, get this one.
Landamath
The glories of the command line. SQLPlus [I am not going to write that irritating asterix] is an acknowledgment of the reality that for many large computer programs and operating systems, a command line utility is vital. The book explains this for the specific instance of hooking to Oracle's database. It is meant as a definitive reference. Showing every command, often accompanied by example code.

For an Oracle DBA, a good acquaintance with SQLPlus is probably mandatory. From the book, you can see how to quickly interrogate the database and get results in various useful paginated formats. Plus, and vitally, you can see how to build script files that can be run, where these files encode your experience in amassing customised sequences of commands specific to your needs. Exactly analogous to batch files in most operating systems, and just as useful.

Along those lines, SQLPlus is conceptually not that hard. When using Oracle, it is often far more important, and harder, to design optimal tables for a given problem.
Manesenci
I had bought this text a few years ago to learn SQL. Little did I know then that SQL Plus is a "sand box" that contains SQL. Needless to say that I was disappointed and had to shelf this book.

However, after reading an introductory book on SQL and writing lots of code, I revisited this text and found it to be quite useful.

In summary, this should not be used by SQL novices. This book teaches "SQL Plus" and not SQL per se. Once, you have learnt the language, this book will come handy to

1, execute sql queries (by scripting)
2, format the report
3, set up the development environment
4, to discover the database
5, and much much more

One reason for not assigning five stars is the lack of ease when it comes to downloading the sample code and installing it on my machine.
Kigul
I've been using the book at home with Oracle 8.0.5 for linux and it has been very helpful - I'm an Oracle novice. I would have rated it higher, but the index and/or grouping of some of the concepts is not consistent. For example, one reader noted that the text refers you to chapter 11 to set your default editor - then does not tell you how to do this in chapter 11. As far as I could see, this is true - chapter 11 does not tell you how to do this - but in chapter 4 there is an *example* that shows how to do this (DEFINE _EDITOR = vi). I liked the sections on report and script writing, I thought they were concise yet easy to follow. Overall, I'd recommend the book to another newbie
Jonathan Gennick and co did a good job here. This "Oracle SQL Plus: The Definitive Guide" would be appreciated by most users, although that advanced SQL users who thirst for a unique guidance, having understood the elementary basics of SQL are its primary target. The medium-sized book boasts of updated and revised information whose accuracy are indisputable. Its methodology is as well, dynamic. The pattern of this book is such that tries to turn difficult issues into entertaining ones. It is worth its asking price.