oracle

Oracle::SQL is a Perl extension for building SQL statements.

SYNOPSIS

use Oracle::SQL;
No automatically exported routines. You have to specifically to import the methods into your package.
use Oracle::SQL qw(:sql);
use Oracle::SQL /:sql/;
use Oracle::SQL :sql;

This is a package initializing object for Oracle::SQL::Builder.

DBD::Oracle is a Perl module with Oracle database driver for the DBI module.

SYNOPSIS

use DBI;

$dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd);

$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);

# See the DBI module documentation for full details

# for some advanced uses you may need Oracle type values:
use DBD::Oracle qw(:ora_types);

DBD::Oracle is a Perl module which works with the DBI module to provide access to Oracle databases.

Every day, a hundred decisions. Heres something that might help.

The Oracle is a Palm application. After installing the executable on your Palm, speak your question, tap the surface of the ball, and the Oracle will give you an answer.

If you dont like the answer, you could perhaps gaze upon the ball until you feel enlightened. Or, ask again!

The Oracle was developed entirely on-board a Palm using the Quartus Forth compiler. If youd like to write your own Palm apps, please check out Quartus Forth!

Oracle::CAPI is a Perl XS wrapper extension for the Oracle Collaboration Suite CAPI SDK.

SYNOPSIS

use Oracle::CAPI;
use Text::vCard;

Oracle::CAPI::SetConfigFile($CAPI_INI_FNAME,$CAPI_LOG_FNAME) && die("Cant init/log CAPI");
$capi_session = Oracle::CAPI::CreateSession() || die("Cant create CAPI session");

# Authenticate to OCS
$rv = Oracle::CAPI::ReconnectAuthUser($capi_session,$HOSTNAME,$nodeid,$pass,$uname);

$rv = Oracle::CAPI::FetchContactsFile($capi_session,$VCARD_NAME_TYPE,$VCARD_STARTSWITH_OP,$chr,$filename);
$rv = Oracle::CAPI::CreateContact($capi_session,$vcard);
$rv = Oracle::CAPI::DeleteContact($capi_session,$uid);

$rv = Oracle::CAPI::DestroyPerlSession($capi_session);

A perl XS wrapper to ctapi.h from the Oracle Collaboration Suite CAPI SDK. This was built and tested against OCS version 9.0.4.2 on Linux.

Oracle::Sqlldr is a Perl wrapper around Oracles sqlldr utility.

SYNOPSIS

use Oracle::Sqlldr;
my $sqlldr = Oracle::Sqlldr->new(); # get new sqlldr object

Oracle::Sqlldr is an object-oriented class that provides a convenient Perl wrapper around Oracles sqlldr utility.

SQL*Loader (sqlldr) is the utility to use for high performance data loading from a text file into a an Oracle database.

Limitations:

· No WIN32 support
· No fixed format record support
· Assumes table owner and user to load data as are the same
· No support for parameter file

GTK Oracle is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing.

Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting.

For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, and the Oracle Automatic Workload Repository in Oracle version 10g. Full statistics are available on loaded statements.

Here are some key features of "GTK Oracle":

· manually running your applications SQL, outside of the application itself
· trying to find out what queries your application is even running
· checking and gathering statistics
· comparing plans
· running statspack to evaluate results
· autotracing
· peeking in AWR
· peeking the shared pool / v$sqlarea / statspack SQL
· identifying high-resource SQL then this might be of some help.

Usage:

· SQL in the text buffer (anything that gets run via the Execute button) is run on its own thread in the background so it will not block the GUI part, and you can cancel it. This execution thread is started when you start up the program, hopefully never exits, and receives commands via a GLib asynchronous queue, so you can safely keep hitting Execute while a command is running, it will just execute them in order.

· If you log in as SYSDBA you will get a combo box just under the main menubar. Changing the value will execute ALTER SESSION SET CURRENT_SCHEMA=somebody; so when you browse it will be as if you were this user. Be aware that any SQL you execute will result in SYS being recorded as the parsing user in the cursor cache, however.

· If you want to access the cursor cache or statspack or AWR you will need to log in with SYSDBA privileges. You might be able to get away with simply having SELECT on SYS.V$SQLAREA and SYS.V$SQLTEXT.

· SYS is excluded from the cursor cache browsing results. Otherwise you end up with a mass of recursive SQL, which you are not going to be able to tune and that is the point here. If youre a masochist and you do want to browse recursives I suppose you can just modify the relevant SQL so that SYS is not exculded and recompile. Have fun.

· AWR features are only available on 10G servers.

· DBMS_OUTPUT works, go to Edit->DBMS OUTPUT Enable

PowerDNS Oracle Backend provides a backend which allows PowerDNS to use Oracle as its data store.

PowerDNS Oracle Backend is a backend driver for the PowerDNS nameserver which allows DNS data to be stored in an Oracle database. PowerDNS can load backend modules at runtime. This backend is fully configurable, and SQL statements can be specified in the configuration file.

Oracle-to-MySQL is a program to move Oracle databases to MySQL server.

Features:

· all Oracle data types (except BFILE and MLSLABEL) and attributes are supported
· works with all versions of MySQL server
· converts indexes with all necessary attributes
· merges Oracle data into an existing MySQL database
· command line support
· converts individual tables
· exports Oracle databases into a dump file
· easy-to-use wizard style interface