eBook PDF Download Digital Library
Author: Jason Price
Publisher: Oracle (McGraw-Hill)
Published: 2002
Total Pages: 626
ISBN-13: 9780072222548
DOWNLOAD EBOOK →This is the only definitive guide to JDBC programming with Oracle8i and 9i. JDBC is the de facto method for accessing an Oracle database from Java.
Author: Dan Hotka
Publisher: Que Publishing
Published: 2002
Total Pages: 644
ISBN-13: 9780789726711
DOWNLOAD EBOOK →Annotation Find out how to use Oracle9i to get a business where it needs to be for the future of the Internet. Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Extend Oracle9i's functionality using the new database environment including: forms, reports, and Web sites built with PL/SQL, Java, XML, and Portal. Increase business interactivity with Oracle9i's new administrative features. Coverage of the following in an easy to learn format: building, monitoring, and tuning an Oracle9i database; learning the enhanced partitioning features of Oracle9i; building Web sites using Oracle9i and PL/SQL, Java, and XML; building forms and reports using Developer 6i; using the popular TOAD development tool; understanding newer tools such as Log Miner; and comprehensive tutorials on SQL and PL/SQL. Dan Hotka is a director of database field operations for Quest Software. He has more than 23 years of experience in the computer industry and more than 18 years of experience with Oracle products. He's an acknowledged Oracle expert, with Oracle experience dating back to the Oracle v4.0 days. His last book is Oracle8i from Scratch (Que) and he has co-authored the popular books Oracle Unleashed, Oracle8 Server Unleashed, Oracle Development Unleashed (all from Sams Publishing), and Special Edition Using Oracle8/8i (Que Publishing). Dan is frequently published in Oracle Professional, and regularly speaks at Oracle conferences and user groups around the world.
Author: Gregory Brill
Publisher: Random House
Published: 2002-08-13
Total Pages: 256
ISBN-13: 067964735X
DOWNLOAD EBOOK →CodeNotes provides the most succinct, accurate, and speedy way for a developer to ramp up on a new technology or language. Unlike other programming books, CodeNotes drills down to the core aspects of a technology, focusing on the key elements needed in order to implement it immediately. It is a unique resource for developers, filling the gap between comprehensive manuals and pocket references. Through real-world examples of PL/SQL queries, stored procedures, triggers, indexing, and more, CodeNotes for Oracle 9i illustrates the complete Oracle database framework, PL/SQL, security, administration, and optimization. Oracle’s integration with Java and support for XML are extensively covered. This edition of CodeNotes includes: • A global overview of this technology and explanation of what problems it can be used to solve • Real-world examples • “How and Why” and “Bugs and Caveats” sections that provide hints, tricks, workarounds, and tips on what should be taken advantage of or avoided • “Design Notes” illustrating many of the common use patterns for Java programs • Instructions and classroom-style tutorials throughout from expert trainers and software developers Visit www.codenotes.com for updates, source code templates, access to message boards, and discussion of specific problems with CodeNotes authors and other developers. Join our nonfiction newsletter by sending a blank e-mail to: [email protected] or visit www.atrandom.com Every CodeNotes title is written and reviewed by a team of commercial software developers and technology experts. See “About the Authors” at the front of the book for more information.
Author: Michael Abbey
Publisher: McGraw Hill Professional
Published: 2002
Total Pages: 546
ISBN-13: 9780072192797
DOWNLOAD EBOOK →The Oracle server. Database objects. Oracle enterprise manager. Distributed computing. Forms and reports overview. Partitioning data.
Author: Gavin JT Powell
Publisher: Elsevier
Published: 2003-12-29
Total Pages: 774
ISBN-13: 0080513298
DOWNLOAD EBOOK →There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert. *Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning *Contains experienced guidance and real-world examples using large datasets *Emphasizes development as opposed to operating system perspective
Author: Chip Dawes
Publisher: John Wiley & Sons
Published: 2006-02-20
Total Pages: 611
ISBN-13: 0782152503
DOWNLOAD EBOOK →Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access
Author: HOLM
Publisher: Apress
Published: 2001-12-23
Total Pages: 0
ISBN-13: 9781861006028
DOWNLOAD EBOOK →While the integration of a Java Virtual Machine into the Oracle database has provided a whole host of new opportunities and challenges to the Oracle developer and DBA, it has also provoked much debate as to when it makes sense to exploit this feature. This book clearly demonstrates many practical, real-world applications that developers can put to immediate use in their day-to-day jobs. With Java and Oracle, the developer can now compress LOBs, use multicast sockets to automatically alert clients when data has changed, and run an FTP Java client in the database, to name but a few of the examples covered here. In addition, this book gives in-depth consideration to the question of when it is appropriate to use Java from a performance perspective, including benchmarks. Who is this book for? This book is for experienced Oracle developers looking to exploit Java. It will be of interest to DBAs who need to know how Java is likely to be used inside the database and how this affects them, and also to Java developers looking to apply their knowledge in the Oracle database. Knowledge of SQL, PL/SQL, and Oracle architecture is assumed. If you are relatively new to Java, then the explanations in the text should allow you to grasp all of the fundamental issues discussed. This book is ideal for an Oracle developer migrating from C to Java. What does this book cover? Java messaging and image generation utilities; Solutions using PL/SQL and Java together; Use of operating system resources; Java application performance; Benchmarks for SQL execution in PL/SQL and Java; Oracle JDBC and SQLJ; A Java tutorial for PL/SQL programmers.
Author: Sam Alapati
Publisher: Apress
Published: 2008-01-01
Total Pages: 1228
ISBN-13: 1430207736
DOWNLOAD EBOOK →This 1,000-page book enables a beginner or intermediate level Oracle DBA or Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases.
Author: Sharanam Shah
Publisher: Shroff Publishers
Published: 2008
Total Pages: 1343
ISBN-13: 9788184045260
DOWNLOAD EBOOK →Designed for new and experienced developers, this book provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of SQL and PL/SQL with examples based on most commonly used business database models. It delves deeply into new features found in Oracle Database 11g, along with existing features found in Oracle Database 9i and 10g.
Author: Steve Vandivier
Publisher: McGraw-Hill/Osborne Media
Published: 2001-11
Total Pages: 660
ISBN-13:
DOWNLOAD EBOOK →Build, deploy, and maintain self-service enterprise portals with Oracle9iAS Portal - the next generation of Internet database software. Includes 3 CD-ROMs containing the official Oracle 9i AS portal product. It uses examples to teach the reader Web development design techniques to improve application efficiency. A clear methodology for Web application development walks the reader through all phases of an Oracle 9i AS portal project. Hand-on examples, simple self-help tutorials, and case studies are provided throughout the book.
