Dear Excel and Oracle Experts,
I have a problem with connecting my Excel Application to an Oracle 10g
r2 database
on Win XP, using an ADO connection :

Does someone know, is there posibility in Oracle(9.2,Windows Platform)get
detail comunication users witch database?
From view DBA_AUDIT_TRIAL I just get kind of query(ACTION_NAME column =
select,insert,etc.)and name of table(OBJ_NAME column).

i would like to import image file into a table with blob format. pls
let me know how to dod this.tq

I wondered why, under VC++ 6, this line compiles :
OCIDateGetDate( dt, &year, &month, &day );
and not this one :

I need a query who can compare the date from one record to the date
from the next record. Can someone help me with this?
I better explain it with a example :
I have 2 tables :

I downloaded earlier Oracle XE and I like it.  Nice web interface for
managing it and developing applications.  It didn't take long to make some
tables with primary keys, sequences, foreign keys, and uploading data via
comma separated values etc.  All very quickly.  I like it I am ...

I am in serious need of help ...
I have a relatively simple program, written in  VC 5, that I am trying
to
use as a CGI "script."  This program connects to an Oracle database

I have a Microsoft Access2002 database that needs to connect to an
Oracle
Database.  I need to map 2 tables from the Oracle DB to retrieve the
proper data.

I am using sqlldr to load one data file into multiple tables. The
oracle version is 9i, sqlldr version is 9.2.0.1.0. My data file has 379
records. The control file looks like following:
==============================================================

I received the following email (excerted below as the orginal is quite
long) at my University of Washington email address:
===================================================================
Good day Sir !

I am trying to teach myself about RAC.  I bought a couple of books, and
I have a few questions I hope someone who's knowlege in this area is
greater than mine can help:
First, I want to set up 2 Red Hat 9.0 boxes.  What would be the minimum

Original data: a huge schema - dump in size of 4-5G, e.g., one of the
"big" tables counts 10,393,403 rows.
We decided to "archive" part of the schema. "Archive" is our internal
application that creates similar empty schema on the same data base and

While whiling away the afernoon a college enquired as to the maximum
number of rows you could have in a table, assuming that Oracle
"numbered" rows.  I explained the rowid concept but then thought,
well...

I want to do the below scenario:
Backup my Oracle 9i db to disk.
Backup the backupsets from disk to tape.
Delete any older backupsets from disk.

Hi my name is lukas im from poland. i dont speak english very well so
sorry if you dont understand me. i dont find anything about it in
polish disciussion groups.
i must create procedure. this procedure has 1 parameter and return CLOB