Mastering Oracle SQL

Putting Oracle SQL to Work

Author: Sanjay Mishra,Alan Beaulieu

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596552473

Category: Computers

Page: 496

View: 8078

DOWNLOAD NOW »
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Troubleshooting Oracle Performance

Author: Christian Antognini

Publisher: Apress

ISBN: 1430257598

Category: Computers

Page: 740

View: 1473

DOWNLOAD NOW »
Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c. What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work. Written for developers by an application developer who has learned by doing Gives a systematic approach to solving database application performance problems Helps you plan for performance as you would for any other application requirement

The Method R Guide to Mastering Oracle Trace Data, Second Edition

Author: Cary V. Millsap

Publisher: Createspace Independent Publishing Platform

ISBN: 9781518897887

Category:

Page: 280

View: 6545

DOWNLOAD NOW »
There are many options these days for measuring and monitoring Oracle(r) Database application performance. This book is about the one that endures as the best foundation there is for understanding Oracle performance: the Oracle extended SQL trace feature. This book is the course book for the 1-day "Mastering Oracle Trace Data" course taught by the author, Cary Millsap. It is not a book about discarding your Oracle fixed views or your monitoring tools that poll them. It is a book about how to look at Oracle performance another way, a way that has worked extraordinarily well for many of us. It's about new ways of thinking about performance using new tools for understanding aspects of your applications that you've never understood before. Contents include: Part one - A coherent framework for understanding all aspects of performance beginning with foundational definitions, case studies illustrating the use of Oracle extended SQL trace data in the performance problem and repair context, detailed descriptions of how to create and obtain extended SQL trace data in different languages and application contexts, detailed explanations of how to understand the story that the trace data is trying to tell you, detailed reference material about Oracle timing measurements and how to use them. Part two - Over 100 pages of worked examples (case studies) illustrating how to analyze and solve performance problems with Oracle-based applications, using the Method R Profiler, Method R Tools, and Method R Trace commercial software packages. Part three - A perspective on why trace files are still important in this modern age of ASH and AWR, and a list of explanations by dozens of Oracle professionals about why they use trace data today.

Oracle Application Server 10g Essentials

Author: Rick Greenwald,Robert Stackowiak,Donald Bales

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596006211

Category: Computers

Page: 262

View: 2398

DOWNLOAD NOW »
The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server. This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server. More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.

ORACLE BUILT-IN PACKAGES. Avec une disquette

Author: Steven Feuerstein,Charles Dye,John Beresniewicz

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565923751

Category: Computers

Page: 931

View: 3632

DOWNLOAD NOW »
A complete reference to the accelerated programming tools built into the PL/SQL language, including those new to Oracle 8, is paired with a diskette providing easy access to the source code and document files developed by the authors. Original. (Advanced).

Designing with Javascript

Creating Dynamic Web Pages

Author: Nick Heinle,Bill Peña

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565923607

Category: Computers

Page: 216

View: 6550

DOWNLOAD NOW »
A guide for beginners offers an overview of JavaScript basics and explains how to create Web pages, identify browsers, and integrate sound, graphics, and animation into Web applications

Beginning Oracle Database 11g Administration

From Novice to Professional

Author: Ignatius Fernandez

Publisher: Apress

ISBN: 1430206284

Category: Computers

Page: 464

View: 6971

DOWNLOAD NOW »
This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

Developing Java Beans

Author: Robert Englander

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565922891

Category: Computers

Page: 298

View: 4375

DOWNLOAD NOW »
Explains how to implement and maintain JavaBeans, covering event listeners and adapters, object validation, property editors and customizers, and using JavaBeans in Visual Basic programs

Oracle 11g: PL/SQL Programming

Author: Joan Casteel

Publisher: Cengage Learning

ISBN: 1133947360

Category: Computers

Page: 528

View: 7629

DOWNLOAD NOW »
Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle11g. ORACLE 11G: PL/SQL PROGRAMMING & ORACLE CD, 2E uses Oracle 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle CD make this book is an invaluable resource in preparing for the new Oracle Certification exam or mastering the PL/SQL programming language with Oracle. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Oracle PL/SQL Programming

Author: N.A

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565923355

Category: Computers

Page: 987

View: 4885

DOWNLOAD NOW »
The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language. Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery. NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk. Oracle PL/SQL Programming is divided into seven parts: Foreword Preface Part I: Programming in PL/SQL 1. Introduction to PL/SQL 2. PL/SQL Language Fundamentals 3. Effective Coding Style Part II: PL/SQL Language Elements 4. Variables and Program Data 5. Conditional and Sequential Control 6. Database Interaction and Cursors 7. Loops 8. Exception Handlers 9. Records in PL/SQL 10.PL/SQL Tables Part III: Built-in Functions and Packages 11. Character Functions 12. Date Functions 13. Numeric, LOB, and Miscellaneous Functions 14. Conversion Functions Part IV: Modular Code 15. Procedures and Functions 16. Packages 17. Calling Stored PL/SQL Functions from SQL Part V: PL/SQL Oracle8 Features 18. Object Types 19. Nested Tables and VARRAYs 20. Object Views 21. External Procedures Part VI: Making PL/SQL Programs Work 22. Code Design Tips 23. Managing Code in the Database 24. Debugging PL/SQL 25. Tracing PL/SQL 26. Tuning PL/SQL Part VII: Appendixes A. What's on the Companion Disk? B. Calling Stored Procedures from PL/SQL Version 1.1 C. Built-in Packages