Oracle in a Nutshell

A Desktop Quick Reference
Author: Rick Greenwald,David Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003364
Category: Computers
Page: 906
View: 3069

Continue Reading →

Oracle Languages - Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database.

Oracle in a Nutshell

A Desktop Quick Reference
Author: Rick Greenwald,David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 1491942959
Category: Computers
Page: 928
View: 7458

Continue Reading →

Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes: Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options. Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database. Oracle Tools--Commands provided with SQLPlus, SQLLoader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack). Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.

Oracle Design: The Definitive Guide


Author: Dave Ensor,Ian Stevenson
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565922686
Category: Computers
Page: 526
View: 8470

Continue Reading →

Oracle Design looks thoroughly at the field of Oracle relational database design. The design of both databases and applications is an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. If the initial design is poor, then the most powerful hardware, the most sophisticated software tools, and the most highly tuned data and programs won't make your system run smoothly and efficiently. Indeed, applications that have been designed poorly will never be able to perform well, regardless of the tuning and retrofitting performed later on. There are three main areas of Oracle design: The design of the specific database objects (e.g., tables, views, indexes, stored functions) that will be implemented in a database. The design of the screens, reports, and programs that will maintain the data and allow inquiries against it. Under certain circumstances, the design must also be concerned with the specific environment or technology (e.g., the network topology, the hardware configuration, and the use of a client/server, parallel processing, or distributed database architecture). This book examines all aspects of database and code design. Part I examines the project life cycle and where design fits in that cycle; it shows a sample case study, identifies the areas of Oracle7 that are of particular interest to designers, takes a look ahead at Oracle8, and provides an in-depth discussion of data modeling (e.g., entities, relationships, attributes, entity models, function hierarchies). Part II describes design issues for the database itself -- denormalization, data types, keys, indexes, temporal data, import/export, backup, recovery, security, and more. Part III explores design issues for specific architectures and environments -- client/server, distributed database, data warehouses, and parallel processing. Part IV describes design issues for the code that accesses the database -- metrics and prototypes, locking, the toolset, design of screens, reports, batch programs, etc. Part V contains summary appendixes. The table of contents follows: Part I: Getting Started with Design 1. Introduction 2. Why is Design so Important for Oracle? 3. Data Modeling Part II: Designing the Database 4. Deciding When to Denormalize 5. Choosing Data Types and NULLs 6. Choosing Keys and Indexes 7. Dealing with Temporal Data 8. Loading and Unloading Data 9. Deciding on Object Placement and Storage 10. Safeguarding Your Data Part III: Designing for Specific Architectures 11. Designing for Client/Server 12. Designing Distributed Databases 13. Designing for Data Warehouse 14. Designing for Parallel Processing Part IV: Designing the Code Modules 15. Introduction to Code Design 16. Determining Where to Locate the Processing 17. Metrics, Prototypes, and Specifications 18. Locking 19. Selecting the Toolset 20. Designing Screens, Reports, Batch Programs, Error Handling, and Help Part V: Appendixes A. Off-the-Shelf Packages B. Tricks of the Trade

Oracle SQL

The Essential Reference
Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565926974
Category: Computers
Page: 382
View: 9269

Continue Reading →

"Oracle SQL: The Essential Reference also contains an extensive discussion of how to tune SQL statements and use the Oracle optimizers to get the best performance from your database when you use SQL. The book covers Oracle8 and Oracle8i (through release 8.1.6)."--BOOK JACKET.

SQL in a Nutshell

A Desktop Quick Reference
Author: Kevin Kline,Brand Hunt,Daniel Kline
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449378936
Category: Computers
Page: 720
View: 1317

Continue Reading →

SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

Oracle Data Dictionary Pocket Reference


Author: David Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596005172
Category: Computers
Page: 140
View: 2402

Continue Reading →

If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your work Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by.

ADO.NET in a Nutshell


Author: Bill Hamilton,Matthew MacDonald
Publisher: "O'Reilly Media, Inc."
ISBN: 1449370438
Category: Computers
Page: 624
View: 4058

Continue Reading →

Written by experts on the Microsoft® .NET programming platform, ADO.NET in a Nutshell delivers everything .NET programmers will need to get a jump-start on ADO.NET technology or to sharpen their skills even further. In the tradition of O'Reilly's In a Nutshell Series, ADO.NET in a Nutshell is the most complete and concise source of ADO.NET information available.ADO.NET is the suite of data access technologies in the .NET Framework that developers use to build applications services accessing relational data and XML. Connecting to databases is a fundamental part of most applications, whether they are web, Windows®, distributed, client/server, XML Web Services, or something entirely different. But ADO.NET is substantially different from Microsoft's previous data access technologies--including the previous version of ADO--so even experienced developers need to understand the basics of the new disconnected model before they start programming with it.Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately.Topics covered in the book include: An Introduction to ADO.NET Connections, Commands and DataReaders Disconnected Data Advanced DataSets Transactions DataViews and Data Binding XML and the DataSet Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell series, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.

Advanced Oracle PL/SQL

Programming with Packages
Author: N.A
Publisher: Oreilly & Associates Incorporated
ISBN: N.A
Category: Computers
Page: 661
View: 5019

Continue Reading →

Demonstrates how to construct and properly build PL/SQL packages, providing a full-use shareware version of PL/Vision and a library of dozens of packages written by the author on the companion disk. Original. (Advanced).

Mastering Oracle SQL


Author: Sanjay Mishra,Alan Beaulieu
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596001292
Category: Computers
Page: 321
View: 9318

Continue Reading →

Explores Oracle's implementation of SQL and explains how to perform tasks including querying time-based data, implementing conditional logic in queries, writing queries, and joining data from two or more tables.

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning


Author: Richmond Shee,Kirtikumar Deshpande,K Gopalakrishnan
Publisher: McGraw Hill Professional
ISBN: 0071483756
Category: Computers
Page: 384
View: 2623

Continue Reading →

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Professional Oracle Programming


Author: Rick Greenwald,Robert Stackowiak,Gary Dodge,David Klein,Ben Shapiro,Christopher G. Chelliah
Publisher: John Wiley & Sons
ISBN: 0764598732
Category: Computers
Page: 790
View: 1918

Continue Reading →

Oracle SQL & Pl/Sql Golden Diary

Refactoring, Interoperability of Versions & Integration of Related Concepts for High Performance
Author: Asim Chowdhury
Publisher: Createspace Independent Publishing Platform
ISBN: 9781539857488
Category:
Page: 292
View: 4752

Continue Reading →

This book covers three aspects 1: Interoperability among database versions 2: Integration of related concepts for performance 3: Creation of Golden Diary in a nutshell by practical examples These intentions have been arisen based on the burning need of database users I have come across throughout my career with roles like PL/SQL developers, Database Administrators, Designers, Data analysts, Performance tuning analysts, Architects, Students, Professors, Interviewees and any DBMS enthusiast or aspirant for oracle certification. Some of these had extensive experience in what they do and have influenced me writing this book. This is an example/research oriented book which will let you navigate between different releases of oracle using alternative approaches to derive similar functionality in different versions of database. For example "Truncate table cascade in 12c and approach prior to 12c" and "Sensitive data masking using REDACTION in 12c and prior to 12c" highlight the intention. Also this book will let you integrate related concepts so that you can ponder over different similar concepts and choose the best option to achieve the best response time and throughput. Examples like "nested loop Join or hash join or parallelism or multi-threading," "Oracle Object CACHE Using Cache or Keep buffer pool or Oracle 12c IN-MEMORY column store " and "Result cache function or deterministic function or PL/SQL collection" highlight the intention. This book will act as a reference guide for learning some very complicated concepts in a simple but precise way which are discussed through various case studies. This will give food for thought while devising mechanism for best possible approach for a database solution given the circumstances. You will learn -Comparative analysis of database features and their usages across Oracle versions -Learn to derive alternate approach for a functionality in different releases of database -Learn related concepts associated with specific challenge -Learn to choose the best approach from the set of related concepts to achieve best result -Familiarize yourself with all concepts with real life example in a nutshell -Learn how to be smart with database and surprise your colleague and boss by your solution The audience of this book would like to cover multiple versions of Oracle and the features it offers. Seeking the best approach for a challenge has not been easy in past as it required a large investment of time and effort to go through the vast amount of documentation. This 270 pages book facilitates that investment, by exploring and churning the vast archives of oracle documentation and producing the output in a nutshell which otherwise readers would need to spend time on.

Secrets of the Oracle Database


Author: Norbert Debes
Publisher: Apress
ISBN: 143021953X
Category: Computers
Page: 450
View: 4358

Continue Reading →

Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server. Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle.

Java in a Nutshell


Author: David Flanagan
Publisher: "O'Reilly Media, Inc."
ISBN: 1449366686
Category: Computers
Page: 1256
View: 8989

Continue Reading →

With more than 700,000 copies sold to date, Java in a Nutshell from O'Reilly is clearly the favorite resource amongst the legion of developers and programmers using Java technology. And now, with the release of the 5.0 version of Java, O'Reilly has given the book that defined the "in a Nutshell" category another impressive tune-up. In this latest revision, readers will find Java in a Nutshell, 5th Edition, does more than just cover the extensive changes implicit in 5.0, the newest version of Java. It's undergone a complete makeover--in scope, size, and type of coverage--in order to more closely meet the needs of the modern Java programmer. To wit, Java in a Nutshell, 5th Edition now places less emphasis on coming to Java from C and C++, and adds more discussion on tools and frameworks. It also offers new code examples to illustrate the working of APIs, and, of course, extensive coverage of Java 5.0. But faithful readers take comfort: it still hasn't lost any of its core elements that made it such a classic to begin with. This handy reference gets right to the heart of the program with an accelerated introduction to the Javaprogramming language and its key APIs--ideal for developers wishing to start writing code right away. And, as was the case in previous editions, Java in a Nutshell, 5th Edition is once again chock-full of poignant tips, techniques, examples, and practical advice. For as longas Java has existed, Java in a Nutshell has helped developers maximize the capabilities of the program's newest versions. And this latest edition is no different.

Oracle DBA Pocket Guide


Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596100493
Category: Computers
Page: 145
View: 3722

Continue Reading →

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs). Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips. Moreover, the Oracle DBA Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning. The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator--new or experienced--interested in reviewing core Oracle concepts at a glance.

Oracle Performance Tuning


Author: Mark Gurry,Peter Corrigan
Publisher: "O'Reilly Media, Inc."
ISBN: 1565922379
Category: Computers
Page: 940
View: 7550

Continue Reading →

A complete revision of the original title, this second edition adds new material on Oracle 7.3 and many Oracle 8 features. It explores new Oracle capabilities like parallel server, parallel query, and distributed database. It contains more detail on constraints and triggers, many more examples, and information on new tuning tools like the Oracle Performance Pack, Oracle Trace, and Oracle Expert.

Oracle PL/SQL Programming

A Developer's Workbook
Author: Steven Feuerstein,Andrew Odewahn
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565926745
Category: Computers
Page: 569
View: 9220

Continue Reading →

Written by one of the world's leading experts on the Oracle PL/SQL language, this text offers extensive exercises in all skill levels covering major features of the language. Also provides a primer to the PL/SQL language.

Oracle Essentials

Oracle Database 12c
Author: Rick Greenwald,Robert Stackowiak,Jonathan Stern
Publisher: "O'Reilly Media, Inc."
ISBN: 1449343171
Category: Computers
Page: 432
View: 3726

Continue Reading →

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions