Oracle


OCA ORACLE Certified Associate
Oracle PL/SQL Developer Certified Associate
OCP ORACLE Certified Professional
Oracle & SQL Server or Oracle vs. SQL Server


ORACLE

The Hitchhiker's Guide to PHP Oracle
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/X Download page
Oracle9i downloads
New to Oracle? Getting started in 2 days for DBAs or Developers
Learn SQL Tutorial SQL tutorial featuring comprehensive guide to SQL language concepts and SQL commands
Oracle Lite
Oracle9i Lite Release Notes for Windows NT/2000/XP Release 5.0.2
Oracle 9i: Web Application Programming for PL/SQL Developers, at Amazon UK
Oracle 9i: Web Development (Oracle Press), at Amazon UK
About: Hands-On With Oracle new requirements for certification
Get Certified Fast with Oracle University
hot-oracle.com
Oracle books at O'Reilly
Full Outer Joins in Oracle9i
DevX
OraWorld Tips - Oracle Training
Oracle Essentials, at Amazon UK
Oracle SQL Tuning Pocket Reference, at Amazon UK
High-performance Oracle: Proven Methods for Achieving Optimum Performance and Availability, at Amazon UK
Database Journal
Experts Exchange
Experts Exchange
Best way to connect VB.NET to Oracle8i
Using .NET Framework Data Provider for Oracle to Improve .NET Application Performance
Oracle Data Provider for .NET
.NET Data Provider for Oracle Released - 23/07/02
Calling Oracle Function via ADO in VB 6
Oracle PL/SQL Programming
PL/SQL: Basic Structure and Syntax
Cursor Variables
CuteSQL a very useful tool for all who work with more than one database system. Allows you to execute SQL commands and queries against any database
Execute Immediate
Execute Immediate added in Oracle 8i
Dynamic Database Access from Client-Side JavaScript
SQL String Functions
Explicit Cursor
Oracle9iR2 Data Warehousing, at Amazon UK
DevArticles
About: ORACLE tutorials etc
Retrieving ADO Recordsets using Reference Cursors
Oracle Web Application Server Documentation Roadmap
PL/SQL Web Toolkit Reference
htp.print() vs. htp.prn() etc
Oracle9i Application Server Release 2 Documentation
Useful PL/SQL Code
Don't Kill That Process - Suspend It!
The Road from Oracle8i to Oracle9i Certification
Oracle9i Central
Table functions, new in Oracle9i
Oracle FAQ
ORACLE Online Library
ORACLE Online Library support page
ORACLE Online Library
Oracle9i Database List of Books PDF files
9i release notes etc
PL/SQL Gateway Overview
Oracle 9i Application Server Using the PL/SQL Gateway Release 1 (v1.0.2.2)
Jump-Start Your Java Development on Linux
Querying Hierarchies: Top-of-the-Line Support
Tuning the Oracle9i Database on Linux
Decision Speed: Table Compression In Action
Handling Exceptional Behavior, Part II
XML: To CLOB or Object?
Securing Java Execution
X Is for XQuery
SQL in, XML out
Building a Code Analysis Utility
From XML to Storage and Back
Make XML Native and Relative
SQL in, XML out Oracle
PL/SQL Forum
SQL*Plus Forum
Buffer Overflow Explained
dbazine.com">dbazine.com
Perils and Pitfalls in Partitioning - Part 2 dbazine.com
Perils and Pitfalls in Partitioning - Part 1 dbazine.com
Journey into Partitioning - Same Goal Many Paths: Part 1 dbazine.com
Select Magazine
International Oracle Users Group Membership costs $125
SQL Standards
Measuring DBA Effectiveness
dbazine.com
A Practical Guide to Data Warehousing in Oracle: Series Introduction
DevX Database Dev Zone
Using SQL*Loader to Load Data
Oracle SQL *Loader FAQ
Oracle9i Database Online Documentation (Release 2 (9.2))
Practical Data Warehousing in Oracle, Part I
A Practical Guide to Data Warehousing in Oracle, Part 2 - 29/01/04
Installation Cookbooks: Installing Oracle9i
Oracle9i Web Services Tutorials
dbasupport.com
Quest surf the pipeline
Useful PL/SQL Code
Oracle9i New Features in PL/SQL
Oracle9i Database Online Documentation (Release 2 (9.2))
PL/SQL Tutorial & Reference
SQL *Plus Command Reference
Basic PL/SQL Block Structure
Exception (error) Handling
Packages
Triggers
To see all the SQL queries that have generated full table scan or fast index scan: look at the v$sql_plan table
DBA Certification Secrets: How to Pass the Tests
Self Test Software
So You Want to Become an Oracle DBA? Part 1 - Getting Close to Oracle
DBA Certification Secrets: How to Pass the Tests
Oracle9i DBA OCP CramSession
Cleaning Up PL/SQL Practices
Code Generation: Declaring War on Deja Code PL/Generator, Table Encapsulation etc
Swyg is active mentoring software - a developer's best friend Show (me) what you've got
OUnit - the Oracle Unit Tester
Hack-Proofing Oracle9i Application Server
Oracle9iAS TopLink By Example
Fast Track to Single Sign-On (SSO) with mod_osso and dynamic directives
Single Sign-On for PHP Pages
Get Started with Oracle and PHP
Scaling Oracle and PHP
Enterprise Application Development Using PHP and Oracle
Cleaning Up PL/SQL Practices
Back to Basics: Constraints (1)
SQL*Plus User's Guide and Reference
SQL*Plus Quick Start
SQL*Plus User's Guide and Reference
SQL*Plus Tips for Oracle Beginners
determining the current session id in oracle
Dev Shed
Concurrency Handling in Oracle: Preventing Locked Data
HelpToFind
Dezign database development tool from DataNamic
Oracle Technology Network free resource for developing applications on the Oracle Internet platform
Oracle Press at Amazon for material on Oracle 8 and 8i
XML and Oracle
Oracle Product Documentation Online
Oracle 8i Lite SQL Reference
Oracle Sample Code
Oracle and Java, JSP, SQLJ, JDBC etc.
Tomcat, Oracle, and JSP sample code
Building Web Applications with Oracle HTML DB, Part 1
Back to Basics: Constraints (1)
Oracle HTML DB List of PDFs
Using CASE Statements in PL/SQL programs
PL/SQL Code Samples
Technical Articles for DBAs and Sysadmins
Technical Articles for Developers
Simplify with Java Stored Procedures
Oracle Free Tutorials
Oracle Administration - Part 1
Oracle Administration - Part 2
Oracle's SPFILE - Part 1
Transitioning to Locally-Managed Tablespaces
Inserting Custom Messages in Oracle Alert/Trace files
Oracle's Wrap Utility for code obfuscation
Bulk Binds and Collects in PL/SQL - Part 2
Oracle Performance Tuning - (Otherwise Known as Drowning in a Pool of Confusion)
Watching SQL Execute on Oracle - Part II
Oracle on Windows Part 3 - The Registry
Watching SQL Execute on Oracle - Part I
Using Cursor Variables As Function Arguments on Oracle 9i
Oracle's SPFILE - Part 2: Examples
Oracle Data Provider for .NET free download: optimized data access to the Oracle database from a .NET environment, allowing developers to take advantage of advanced Oracle database functionality. The data provider can be used from any .NET language, including C# and Visual Basic .NET
Oracle Administration - Part 2
Oracle 2020: A Glimpse into the Future of Database Management, Part 1
How Bulk Binds in PL/SQL Boost Performance
No Reading Between the Lines: The Importance of Documenting
Building Web Applications with Oracle HTML DB, Part 2
MRIS Property Listings on Standard Edition
Oracle9i Analytic SQL Features, Part 1
Oracle9i Analytic SQL Features, Part 3
Oracle9i Analytic SQL Features, Part 4
Oracle9i Analytic SQL Features, Part 5
Oracle9i Analytic SQL Features, Part 6
Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
Installing the Oracle WebServer PL/SQL Web Toolkit
HTML DB
Take Advantage of Oracle in .NET
An Expert's Guide to Database Solutions: Free SQL Code Beautifier - 21/02/05
SQLinForm
An Expert's Guide to Database Solutions: Yet Another Web Based DBA Tool for Oracle - but FREE - 22/02/05
oracletool.com interactive, web based application that runs as a CGI script using your web server
Share Your Data as XML
Using Oracle9i to simplify database creation and management
ORACLE Database Administration
Oracle Web Application Programming for PL/SQL Developers, at BookPool
PL/SQL Web Toolkit Oracle9i - how to set up the Database Access Descriptor Configuration (DAD)
Connecting to an Oracle Database Using ASP.NET - A Step-by-Step Tutorial - 29/10/04
View Server/Database name in Oracle 9i - 08/08/05

Oracle10g

Build a PL/SQL Web Service
Oracle10g downloads
Regular Expressions in Oracle 10g
Build a PL/SQL Web Service
An Introduction To Oracle Warehouse Builder 10g
Oracle Database 10g Does More, Demands Less
Build a PL/SQL Web Service 10g
Utilities for Starting and Stopping Oracle 10g Databases
The Oracle 10g Scheduler, Part 1: Overview
Introduction to Oracle 10g's New SQLAccess Advisor
Oracle 10g's Redo Logfile Sizing Advisor
True Session Wait Activity in Oracle 10g
Introduction to Oracle 10g's New SQL Tuning Advisor
Oracle HTML DB comes FREE with Oracle Database 10g
Installing Oracle Database 10g on Linux x86
Oracle 10g HTML DB a rapid web application development tool for the Oracle database
Oracle Database 10g New Features: The Oracle Database Advisors
Orientation to the Linux Filesystem Hierarchy for Oracle10g Users
11i vs 10g: Whats the difference?
Oracle readies second grid database - 19/06/05
Understanding Optimization Improvements in the Oracle Database 10g Optimizer make it even more valuable for tuning
Oracle10gCertification.com
Strong SQL Made Even Stronger: Oracle 10g SQL Enhancements, Part 1 - 27/07/05 including upgrades to the MERGE command, enhancements to hierarchical query capabilities, and improvements to query and access methods for nested tables

Books

Oracle High Performance Tuning for 9i and 10g, at Amazon UK
The Art and Science of Oracle Performance Tuning, at Amazon UK
Optimizing Oracle Performance, at Amazon UK
Mastering Oracle PL/SQL: Practical Solutions, at Amazon UK
Oracle Replication, at Amazon UK
Programming Oracle: Triggers and Stored Procedures, at Amazon UK
Oracle DBA Backup and Recovery Quick Reference, at Amazon UK
Oracle DBA Sql Quick Reference, at Amazon UK
Oracle Pl/Sql by Example, at Amazon UK
Oracle (10g) Regular Expressions Pocket Reference, at Amazon UK
Conducting the Oracle Job Interview, at Amazon UK
Oracle Performance Troubleshooting, at Amazon UK
Creating a Self Tuning Oracle Database, at Amazon UK
Expert One-on-One Oracle, at Amazon UK
Effective Oracle by Design, at Amazon UK
Oracle9i: The Complete Reference, at Amazon UK
Oracle9i PL/SQL Programming, at Amazon UK
Oracle Utilities, at Amazon UK
Oracle DBA Guide to Data Warehousing and Star Schemas, at Amazon UK
Oracle9iR2 Data Warehousing, at Amazon UK
Oracle Data Dictionary Pocket Reference, at Amazon UK
Oracle9i Performance Tuning Tips and Techniques, at Amazon UK
Oracle PL/SQL Language Pocket Reference, at Amazon UK
Oracle PL/SQL Built-ins Pocket Reference, at Amazon UK
Oracle 9i Web Application Programming for PL/SQL Development, at Amazon UK
Oracle9i PL/SQL: A Developer's Guide, at Amazon UK
Single Access Point for Oracle Administrators through the Web
Oracle Security and Auditing, Part 1: Securing Listener through a Password
dba-oracle.com
Influencing Oracle's Cost-Based Optimizer, Part 1
Pro .NET Oracle Programming, at Amazon USA
Expert One-on-One Oracle, at Amazon USA very good reviews
Oracle9i: The Complete Reference, at Amazon USA the reviewers either love or hate this one
Oracle Database Programming Using Java and Web Services, at Amazon USA

News

Oracle takes on foes with new price plan - 14/06/01 forthcoming release 9i will be fast but cheap
Built-in XML: Oracle's sales salvation? - 15/05/02 Oracle is set to launch a new version (9i) of its flagship database software
Oracle e-mail targets cash contributions - 12/06/02 Oracle sleaze!
Calif. scraps agency at heart of Oracle flap - 04/07/02
Oracle touts new 9i technology - 08/07/02
Ellison: No funny business at Oracle - 30/07/02
Oracle's Java tools get makeover - 29/10/02
Tech giants prep high-powered databases - 12/12/02
Oracle polishes portal software - 17/01/03 part of its 9iAS application server
Monster: Oracle Jobs
Oracle adds standard to server software - 27/02/03 the upcoming Oracle9i Application Server will help eliminate the need for proprietary programming skills by providing one tool to define, create and connect business processes
Oracle hangs on to database lead - 10/03/03
Oracle targets BEA customers - 31/03/03 Oracle9i Application Server Java Edition
Dell, Oracle cluster together - 02/04/03
Oracle plans $5.1bn bid for rival - 06/06/03
Oracle aims small with database - 08/10/03 Customers can pay $195 per user, with a minimum of five people, allowing a company to purchase a database for less than $1,000
Average Annual Salary By Region
Oracle targets Microsoft with database update - 06/11/03
Oracle apps to work with Mozilla - 16/01/04
Oracle begins shipping 10g database - 02/02/04
Oracle's profit growth picks up - 15/03/04
Oracle delivers simplified Java tools - 14/04/04
Oracle to finish Linux makeover this year - 26/05/04
Market research gives Oracle top database spot - 07/06/04
Oracle puts patches on a schedule - 19/08/04
Oracle delivers delayed patches - 01/09/04
Oracle serves up lower-cost app server - 07/09/04
Oracle9i Analytic SQL Features, Part 1 - 13/09/04
Oracle releases Data Hub for products - 24/05/05
Database sales up 10 percent; IBM, Oracle tied for lead - 24/05/05
Quest Software Expands Breadth of Toad For Oracle with new Functionality for Database Developers and DBAS - 01/06/05
Software Fixes Oracle Automatically - 25/07/05 Albuquerque-based Patchwork Systems aims to start marketing software that will manage and automate the implementation of the hundreds of fixes issued by Oracle every year
Oracle Error ORA-20000 - 26/07/05
Oracle wants to rein in database admins - 25/04/06

IDE's etc

TOAD Pocket Reference for Oracle, at Amazon UK for £8.95 or Amazon USA
ToadSoft
TOAD by Quest Software Review and comparisons with other software
PL/SQL Developer more heavy-duty than TOAD?
EZSQL
SQL Navigator
Rapid SQL
TOAD Pocket Reference for Oracle, at Amazon UK
The Toad Handbook, at Amazon UK

Third Party

DBScripter creates a script from any Oracle database's data, objects and/or source
OraEdit powerful FREE editor designed specifically for Oracle
Confio Software's DBFlash for Oracle Identify the Wait-Events causing database bottlenecks etc

User Groups

Oracle User Groups
UK Oracle User Group


Chris's Computing Links

Chris's Homepage