(Larger Image)
|
Oracle Programming with Visual Basic
by Nick Snowdon
Product Group: Book
Publisher: Sybex Inc (1998-10-14)
ISBN: 0782123228
EAN: 9780782123227
UPC: 025211223222
Dewey Decimal #: 005.7585
Binding/Media: Paperback - 715 pages
SKU: 0901300028
Condition: Used: Like New
Comments: clean and unmarked, light shelf rubs, too large for expedited or international- Thanks!
|
Editorial Reviews
|
Product Description
Despite repeated attempts, including failed products, Oracle has been unable to create a development tool which will solve the problem with getting information out of the database and into the hands of managers and users. But, now here is a source to build quick and effective programs for inputting information into an Oracle database or creating reports. The book has been technically reviewed by the Microsoft developer support team and by an Oracle employee to insure the highest possible level of technical accuracy.
|
Amazon.com Review
Aimed at programmers who are familiar with Visual Basic and who have been exposed to Oracle, this instructional text covers the popular Oracle/Visual Basic client/server combination from beginning to end. The book opens with a lengthy discussion of the unique architecture of Oracle. The author presents the basics of Oracle's components, database administration processes, and database design issues. By the end of this first part, the reader comes away with a solid understanding of Oracle. The second part adequately covers queries and store procedures and introduces the reader to Oracle's PL/SQL. Next, the author devotes a section to implementing Visual Basic client applications against the Oracle back end. He presents Open Database Connectivity (ODBC), cursors, and object linking and embedding database (OLE-DB) as well as discusses the Microsoft JET engine, remote data objects, and ODBCDirect. All of these architectures are critical to expert database programming in Visual Basic. The book also addresses other client design issues, such as transaction control and error handling. Oracle Programming wraps up with a section on advanced Oracle techniques that includes Oracle Objects for OLE--otherwise known as OO4O. Generous but concise code examples, smart sidebars on real-world implementation, and plenty of architectural diagrams round out this book. --Stephen Plain
|
Customer Reviews
|
A little Misleading
Rating  (2)
Date: 2002-07-16
3 out of 3 customers found this reveiw helpful
This book is really the vb programmer's guide to Oracle. This is a good general reference but it does not get into depth on visual basic side. THis book would be good for someone with little knowledge of how Oracle works.
|
|
Oracle Demystified, Not Just For VB Programmers
Rating  (5)
Date: 2001-08-06
5 out of 5 customers found this reveiw helpful
Oracle owns the relational database server market and Microsoft owns the desktop market. Visual Basic is the language of choice for the WinTell development world. One would expect dozens of books available to support this paradigm, but there are not.I recommend this book to everyone who must use Oracle. The first 10 chapters summarize Oracle better then Oracle summarizes Oracle. Snowdon assumes that the reader is familiar with SQL Server, but he does not assume ANY Oracle knowledge. By the time this book was available I had already written two production class programs for Oracle without the benefit of experienced Oracle DBA's to help me. This book would have saved me hours of frustration had it been available. I have just purchased Dov Trietsch's, "Visual Basic Oracle 8 Programmer's Reference," so I cannot compare the two. If you are going to survive in an Oracle environment, you will need to learn PL/SQL, Oracle's extended SQL programming language for triggers and stored procedures. Snowdon has an excellent introduction, but the definitive source is Steven Feurerstein's "Oracle PL/SQL Programming" by O'Reilly and Associates. I DO NOT recommend any of the Osborne books on Oracle, even though they are Oracle's vendor of choice. Oracle makes a big chunk of its money in consulting fees and, in my opinion, the Osborne documentation protects that revenue stream.
|
|
Heavy in Theory, Better Examples Elsewhere
Rating (2)
Date: 2000-12-09
11 out of 12 customers found this reveiw helpful
If you compare the size of this book with Dov Treitch's Visual Basic Oracle 8 (wrox), you might think you could get further using this book. That may be true if you're interested in doing Oracle dba tasks. But this book is titled "Oracle Programming".The first 6 chapters, 210 pages, are dedicated to Oracle architecture and administrative tasks, such as deploying an Oracle db. In my opinion, if you're programming you may need to know about 10 pages worth of this info, good luck finding it, and if you're doing dba work on an enterprise server watch out if you've only read these 200 pages. Then, when it comes to actual programming an app against Oracle the book also falls way short of the wrox title. There is not a single example in the book that actually demostrates how to create a FORM (remember those?) that links to Oracle. Published in 1999 the code is also behind, with large sections of the book dedicated to DAO, RDO, and ODBC Direct. And, as others have stated, the code describing the use of stored procedures is either wrong or out of date. If you want to read a long book, get this one. There are some good, clear descriptions of the theory behind cursors and the mechanics of the various middleware connection layers. If you actually want to develop against Oracle, get the wrox book!
|
|
Oracle, VB, and Rock Stardom
Rating  (4)
Date: 2000-06-22
13 out of 13 customers found this reveiw helpful
There are very few books with "Oracle" and "Visual Basic" in the title. This is unfortunate for developers that want to gain insights into developing quality solutions with those technologies. This is especially so when the developer does not have the benefit of Oracle / VB experienced peers. Fortunately, however, Mr. Snowdon provides us with a well written book on both subjects under one title. The content is quite broad and rather simple and the examples are easy to test out. With that being said, this is definitely a great book for the novice (an experienced VB developer with little experience with Oracle or vice versa or just a plain ol' novice). Beginners could swallow it too, however, the breadth of content may prove somewhat daunting. The senior developer may encounter a degree of frustration with the simplicity or generality of some of the content, but oh well I guess...I found the following discussions very useful: Oracle physical architecture, data access (specifically ADO and the use of DSN-less connections), calling Oracle stored procedures and functions). I should mention that about half of the book deals with basics such as database design, SQL, VB, etc. So, if you need to get up to speed fairly quickly and you're not building a monolithic OLTP system then this is a good addition to your library. Besides, the price is right. I also recommend Dov Trietsch's 'VB Oracle 8' from Wrox which is better for the more advanced VB programmer (use of classes and better coverage of ADO especially in the area of dealing with server sided objects--stored procedures and server sided PL/SQL cursors).As a final remark let me add that Oracle developers with VB skills (or vice versa, yet again) are capable of commanding large salaries or hourly rates. This is your opportunity as a computer geek to get the recognition you deserve and to live like a rock star. Order yours now!
|
|
One of the best how-to's I've ever read.
Rating (5)
Date: 2000-04-07
2 out of 2 customers found this reveiw helpful
This book is fantastic for moderate to experienced VB programmers that have a need to use Oracle. I don't know what I would have done without it. Because the ADO and Oracle do not mesh perfectly, there are definitely some tricks to know, especially for using stored procedures (a must in any enterprise level application). Like I said, a great resource.
|
|
|
|
|