Author : David C. Kreines
Publisher : "O'Reilly Media, Inc."
Page : 428 pages
File Size : 20,38 MB
Release : 2000
Category : Computers
ISBN : 9781565926974
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.
Author : Catherine Fisher
Publisher : Hodder Children's Books
Page : 295 pages
File Size : 19,56 MB
Release : 2010-10-07
Category : Juvenile Fiction
ISBN : 144490289X
The final story in the Oracle sequence. We are again in the distand land of deserts and islands ruled by one god whose wishes are conveyed through the Oracle. The Archon, child god-on-earth, returns from his journey across the desert to the Well of Songs, to find the tyrannical General Argelin has siezed control and his reign of madness is oppressing the Two Lands. He has publicly denounced the gods, and established a reign of terror. Mirany is in hiding, and the Nine are scattered. Will Argelin's obsession bring the Rain Queen's wrath down on them all? And whose is the sinister new power hidden in the sign of the Scarab? In the descent into anarchy, Mirany and the Archon must attempt the final, impossible journey of the soul. Through the Nine Gateways into death. And back.
Author : Catherine Fisher
Publisher : Paw Prints
Page : 0 pages
File Size : 32,75 MB
Release : 2009-04-09
Category :
ISBN : 9781439550076
Author : Thomas Kyte
Publisher : Apress
Page : 764 pages
File Size : 32,84 MB
Release : 2006-11-07
Category : Computers
ISBN : 1430200677
* Based on a proven best-seller and written by the most recognized Oracle expert in the world and f * Fully revised book, covering bothfor the 9i and 10g versions of the database * Based on what is widely-recognized as the best Oracle book ever written. It defines what Oracle really is, and why it is so powerful * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It defines what Oracle really is, and why it is so powerful It and it tackles the problems that developers and DBAs struggle with every day
Author : David Kreines
Publisher : O'Reilly Media, Incorporated
Page : 586 pages
File Size : 38,13 MB
Release : 1999-04-14
Category : Computers
ISBN : 9781565925168
Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.
Author : Jonathan Lewis
Publisher : Apress
Page : 276 pages
File Size : 15,49 MB
Release : 2012-01-29
Category : Computers
ISBN : 1430239557
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica
Author : Gavin JT Powell
Publisher : Elsevier
Page : 683 pages
File Size : 22,92 MB
Release : 2004-10-15
Category : Computers
ISBN : 0080479839
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code* Authors have four decades of commercial experience between them as developers and database administrators
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 1028 pages
File Size : 18,64 MB
Release : 2002
Category : Computers
ISBN : 9780596003814
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.
Author : Michael McLaughlin
Publisher : McGraw Hill Professional
Page : 865 pages
File Size : 29,1 MB
Release : 2008-04-19
Category : Computers
ISBN : 0071643567
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit
Author : Thomas Kyte
Publisher : Apress
Page : 811 pages
File Size : 33,19 MB
Release : 2014-11-10
Category : Computers
ISBN : 1430262990
Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Revised to cover Oracle Database 12c Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database’s most powerful features
