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: 6043

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: 381

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.

SQL in a Nutshell


Author: Kevin Kline,Daniel Kline,Brand Hunt
Publisher: "O'Reilly Media, Inc."
ISBN: 0596518846
Category: Computers
Page: 578
View: 9137

Continue Reading →

"SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, MySQL 5.1, and PostgreSQL 8.3. You'll also get an overview of the Relational Database Management System (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts." --Book Jacket.

Advanced Oracle PL/SQL

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

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).

Oracle SQL

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

Continue Reading →

SQL (Structured Query Language), the heart of a relational database management system, is the language used to query the database, to create new tables in the database, to update and delete fields, and to set access privileges. Aimed at everyone who needs to access an Oracle database using SQL, including developers, DBAs, designers, and managers, this book delivers all the information they need to know about standard SQL, and Oracle's extensions to it.

Oracle Design: The Definitive Guide


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

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 Data Dictionary Pocket Reference

Views, Columns & Tips
Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 1449366805
Category: Computers
Page: 146
View: 8181

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 workOracle 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: 1787

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.

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: 5230

Continue Reading →

SQL in a Nutshell

A Desktop Quick Reference Guide
Author: Kevin Kline,Daniel Kline,Brand Hunt
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596554255
Category: Computers
Page: 594
View: 6232

Continue Reading →

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

Oracle Performance Tuning


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

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 DBA Pocket Guide


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

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.

Mastering Oracle SQL


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

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.

Secrets of the Oracle Database


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

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: 6513

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 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: 6235

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.

Oracle Database Programming using Java and Web Services


Author: Kuassi Mensah
Publisher: Digital Press
ISBN: 9780080525112
Category: Computers
Page: 1120
View: 9265

Continue Reading →

The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers. Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples. Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database. Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database. Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases. Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered databases (RAC) in Grid environments. Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC. Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer. Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.

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: 9895

Continue Reading →

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).