» » Mastering Oracle SQL and SQL*Plus

Download Mastering Oracle SQL and SQL*Plus fb2

by Lex deHaan
Download Mastering Oracle SQL and SQL*Plus fb2
Programming
  • Author:
    Lex deHaan
  • ISBN:
    1590594487
  • ISBN13:
    978-1590594483
  • Genre:
  • Publisher:
    Apress; 1st Corrected ed., Corr. 2nd printing edition (March 28, 2006)
  • Pages:
    468 pages
  • Subcategory:
    Programming
  • Language:
  • FB2 format
    1348 kb
  • ePUB format
    1974 kb
  • DJVU format
    1224 kb
  • Rating:
    4.8
  • Votes:
    389
  • Formats:
    lrf azw lit mobi


Syntax of SQL Plus commands and Oracle specific SQL is interspersed throughout the book's chapters, introduced as those commands are needed by the author's examples

Syntax of SQL Plus commands and Oracle specific SQL is interspersed throughout the book's chapters, introduced as those commands are needed by the author's examples. I initially felt a bit disappointed by this approach until I noticed the thoroughness and organization of appendix A "Quick Reference to SQL and SQL Plus".

Mastering Oracle SQL and SQL Plus. This book is fully compliant with the latest version of the ANSI SQL standard, and fully updated for the Oracle 10g database. And author Lex de Haan is vastly experienced with the Oracle database, and has 25 years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body. Show all. About the authors.

It is a true honor to be asked to write an introduction to a book by Lex de Haan. and sheer energy in the many years we’ve been doing things in the Oracle world. Lex spent 14 years in Oracle, starting as an instructor in Oracle Netherlands, becoming initiator and coordinator of Oracle’s excellent Technical Seminar business, and finally ending up in Oracle’s Curriculum Development division as a manager for a bunch of very excellent course developers.

Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience

While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples. This book is an effective tool for you to write effective SQL for the Oracle database. Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience.

Start by marking Mastering Oracle SQL and SQL Plus as Want to Read . This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics

Start by marking Mastering Oracle SQL and SQL Plus as Want to Read: Want to Read savin. ant to Read. This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics.

This repository accompanies Mastering Oracle SQL and SQLPlus by Lex deHaan (Apress, 2005). Download the files as a zip using the green button, or clone the repository to your machine using Git. Releases. Release v. corresponds to the code in the published book, without corrections or updates. See the file Contributing. md for more information on how you can contribute to this repository.

Ideal for anyone who wants to learn SQL programming for Oracle database. Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database. Book can be used as collateral/handouts for SQL training courses at universities/ high schools.

Автор: Lex deHaan Название: Mastering Oracle SQL and SQL Plus Издательство . Описание: Discusses how to create dynamic client/server applications using PL/SQL and the information contained in this volume.

Описание: Discusses how to create dynamic client/server applications using PL/SQL and the information contained in this volume.

Oracle Advanced PL/SQL Developer Professional Guide: Master advanced PL/SQL concepts along with plenty of. .Oracle-specific SQL extensions do we deviate from the international standard.

Oracle Advanced PL/SQL Developer Professional Guide: Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination. 16 MB·6,129 Downloads.

*Ideal for anyone who wants to learn SQL programming for Oracle database.

*Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database.

*Book can be used as collateral/handouts for SQL training courses at universities/ high schools.


Cemav
First the negatives of the book:
* Page numbers are missing from all pages except the first page of each chapter. This is not a critical problem until one attempts to use the index at the back of the book to locate a specific topic.
* The initial word in a couple of paragraphs is missing.
* The left-most column of table 2-5 "SQL Arithmetic Operators" is blank. The left-most column of table 4-2 "SQL Comparison Operators" is blank.
* Between listing 9-14 and 9-15 (approximately page 244) the book states that an ORDER BY is executed before a ROWNUM filter in the WHERE clause is applied, when in fact the ORDER BY is applied after the ROWNUM filter is evaluated (based on the pre-existing order of the rows in the table blocks) - meaning that the desired rows from the query would not be returned, and that is why the inline view is required.
* The book states that GROUP BY requires a sort operation, but that is no longer the case with more recent releases of Oracle (it was a correct statement as of the original publication date).
* The front cover of the book states that the book includes a CD with a developer's license for Oracle 10g (version 10.1.0.2). No CD is included with the book, however a version of Oracle with a developer license may be downloaded from Oracle's OTN website.
* The book has limited coverage of analytical functions.

Like many of the Apress books, this book is extremely well written with a thoughtful layout and a careful progression of topics. This approach will help to advance the skills of readers who are just beginning to understand how to write Oracle SQL statements, and there is sufficient coverage of "newer" (or little known) syntax to assist long-term intermediate and advanced users of Oracle SQL in finding better ways of attacking old coding problems (using UPDATE against an inline view, instead-of-triggers, outputting HTML from SQL*Plus, regular expressions, INSERT ALL, SYS_CONNECT_BY_PATH, etc.).

Syntax of SQL*Plus commands and Oracle specific SQL is interspersed throughout the book's chapters, introduced as those commands are needed by the author's examples. I initially felt a bit disappointed by this approach until I noticed the thoroughness and organization of appendix A "Quick Reference to SQL and SQL*Plus". For an intermediate to advanced user of Oracle SQL and SQL*Plus, that section of the book will prove invaluable when trying to determine if the correct linking syntax for a SQL statement is "ON", "IN", "OVER", "FROM", "TO", or "OF". For a beginner, that section of the book while help to quickly determine if a SQL command exists for a specific task.

Even with the negatives outlined at the beginning of this review, most of which appear to be typesetting issues, this book is still the best Oracle SQL reference that I have found so far, providing just enough detail to help a person to become productive when interacting with Oracle databases, without overwhelming the reader with 20 variations of different SQL statements which accomplish the same basic task. I just wish that I had found a book of this caliber a decade earlier.
TheJonnyTest
The best introduction to SQL around. Period.
This book is one of those rare instances in which an exceptionally savy author dedicates his knowledge and patience to the beginner in his field, instead of choosing the easy road of writing only high brow, terse and generally useless articles. The pace is gentle but fast enough to keep you interested, presentation style if fantastically clear and engaging. The teaching strategy is hands on and includes a through tutorial of SQL Plus, the essential tool for practicing and sharpening your SQL skills on Oracle.
Exercises are included and Lo and Behold, solutions are also given to all exercises, contrary to the usual sad practice in most technical books and textbooks. Ideal for teaching a class or self-study.
It's very sad that Lex De Haan left us, but we are lucky to have books like this in which his knowledge, talent and experience live on and can be precious to many database students and professionals.
Thank you, Lex.
Perdana
Disappointed; although quite lengthy in its treatment of the subject matter what use is an index when the pages are not numbered? In addition, the much touted companion CD, where is it?
Knights from Bernin
I have been doing a survey of Oracle books since I have a need to learn this database.. I took this book out of the library and I was looking at some of their samples that look like they have been thrown out there expecting you to get the data behind them. I went online to Apress looking for the source code and downloaded it only to find that the data is missing from the tables (actually all the code contained simple select statements).

If you are learning SQL, and they are presenting how to you functions, they should provide the data as a download, included CD or some other format. Otherwise, the reader will have no clue behind what they are trying to show you...

For example, in chapter 4 they are showing the difference between using the select statement with and without the distinct attribute. According to their discussion their are 8 rows displayed instead of 14 except what is the original data entered into the table? Am I missing something?

The only good book that I found is Oracle Database by Jason Price. Even though he focuses on some small stuff he is coherent, complete and thorough in his presentation. In addition the complete source code can be downloaded from the web. The only thing is that he stuffs a lot of the examples into a few files but you can easily cut the information out that you need (at least the table data is provided to the user which really helps)...

Update:

This past week, I went to the Apress website and filled out an errata on this book... Even though, they said the writer will be contacted, I do not think anything will come about changing this issue (even though I do not believe it is a major fix).
Xellerlu
The book presupposes no prior knowledge of Oracle SQL, or indeed of any SQL. de Haan writes for someone willing to study alone from this text, without benefit of the classroom.

Ah, but before I go further, I should add that there is one very attractive feature. The book has a CD with Oracle 10g for Microsoft Windows, and an associated Developer's License. You will need to install it to handle the many exercises he poses. (Another plus of the book.) But one can easily imagine an experienced developer getting the book for the CD alone.

Now if you do need to learn Oracle SQL, de Haan proceeds at a careful pace. He gives you the syntax in understandable chunks; not too much to overwhelm. SQL syntax diagrams can be formidable in their full glory. But piece by piece, you should be able to assimilate the content.

de Haan has also tried to keep to standard SQL syntax, as much as possible. At the level of an expected reader of the book, this is probably best. Oracle specific variants (just like other vendors' variants) tend to arise in more advanced contexts.