Navicat for Oracle is a powerful Oracle Database Server administration and development tool. It works with any Oracle version from 8.1 to the newest one and supports all Oracle objects including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, Type and so on. It is also not only sophisticated enough for professional developers, but also easy to learn for new users. With its well-designed Graphical User Interface(GUI) and well-described wizard system, Navicat for Oracle lets you quickly and easily create, organize, access and share information in a secure and easy way. Navicat for Oracle is available on two platforms - Microsoft Windows and Mac OS X. It can connect users to local/remote Oracle Server, providing several utilitarian tools such as Data/Structure Synchronization, Import/Export and Report to facilitate the process of maintaining data.

SpViewer Enterprise is the most advanced product in spViewer product tool set. This unique product is intended for large enterprises providing a convenient framework to manage and analyze Oracle STATSPACK and AWR performance data of complex enterprise Oracle database environments. This product provides support for all the current versions of Oracle STATSPACK utility starting with 8.1.7 up to Oracle Release 11.1.0. This product supports most of the latest Oracle10g and 11g performance tuning features like Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) and others.

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery.

This toolkit dramatically cuts the effort, cost, and risk of migrating to/from any of the following database/file systems: Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus, dBase, CSV/Text and transfer any ODBC DSN data source to them

More than 256 migration methods in one toolkit. i.e.
* From / to Oracle 8i/9i/10g/11g migration
* From / to SQL Server 6.5/7.0/2000/2005/ 2008 migration
* From / to MySQL 3.23/4.x/5.x migration
* From / to PostgreSQL 7.x/8.x migration
* From / to IBM DB2 5.x/6.x/7.x/8.x/9.x migration
* From / to Access 95/2000/2003/2007 migration
* From / to Excel 95/20002003//2007 migration
* From / to Visual Foxpro (free DBF/DBC) migration

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

* Explore SQL Plus and SQL Developer
* Use SQL SELECT, INSERT, UPDATE, and DELETE statements
* Write PL/SQL programs
* Create tables, sequences, indexes, views, and triggers
* Write advanced queries containing complex analytical functions
* Create database objects and collections to handle abstract data
* Use large objects to handle multimedia files containing music and movies
* Write Java programs to access an Oracle Database using JDBC

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle.

This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running intiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements forimplementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly

How to assess potentialthreats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logsand other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newestrelease of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Ron Ben Natan "HOWTO Secure and Audit Oracle 10g and 11g"
March 2009 | English | ISBN-13: 978-1-4200-8412-2 | 472 Pages | PDF | 7.16 MB

Oracle is the number one database engine in use today. The fact that it is the choice of military organizations and agencies around the world is part of the company’s legacy and is evident in the product. Oracle has more security-related functions, products, and tools than almost any other database engine. Unfortunately, the fact that these capabilities exist does not mean that they are used correctly or even used at all. In fact, most users are familiar with less than 20 percent of the security mechanisms within Oracle.

The answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.Do you need to design, visualize or document your database? ModelRight can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.

Do you need to control the most detailed aspects of your physical database?
ModelRight has more complete and in-depth support for your database's (currently Oracle, SQL Server, MySQL, and database via ODBC) most advanced features. In addition, it includes a sophisticated modern user interface that will allow you to edit your diagrams and navigate among them with ease.

ModelRight provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.

Product Description
Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.
Gets you started in all key areas of database administration
Provides a sound foundation on which to build your career
Written in a clear, to–the–point style by Oracle expert and popular speaker Iggy Fernandez

Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle 11g for the enterprise, and Microsoft Access 2007 for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before!

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle significantly improved triggers.

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.
Explore SQL Plus and SQL Developer
Use SQL SELECT, INSERT, UPDATE, and DELETE statements
Write PL/SQL programs
Create tables, sequences, indexes, views, and triggers