I'm using Windows XP. I want to connect to a remote Oracle 10g
database. I have installed the Instant Client 10.2.0.1.0 Basic Lite and
the ODBC package. The directory is included in the PATH and ORACLE_HOME
is set to that same directory. The ODBC package includes a file

hi all
i have a procedure like this  (in package CORP_REPORT):
PROCEDURE Confronto
(  IN_IDREQUEST IN NUMBER,

Is any way to use regular expressions on 9.X Oracle databases, and how?
Or it is 10g feature???

This message is cross-posted to 2 groups because of making comparsons.
When I review SQL Server 2005 functions, and get to know languages
called MDX, DMX, XML/A. MDX is kinda dimenstional version of SQL, which
Oracle seems to try to include as extension to SQL such as "group by

i have this query,
and i can notice that logical reads are by far larger that phisical
ones, yet, the rows retrived are few.
Since the quere seems to be taking an acceptable execution plan (to me

Hi Folks,
after rebooting one node of a cluster after configuring the backup nic, I
got the message:
[ID xxxx user.alert] Oracle CSSD failure.  Rebooting for cluster

I have been a sys admin for a while now, going on 8 years.  I support
systems with various versions of Oracle running on Solaris. I have
always threatend to actually learn something about Oracle and I am
finally beggining that journey.

i am so new on oracle.
My problem is i cannot delete rows from a table.Look like deleted but
it is not :D
i am working on web application which works with ASP.

Is there any available piece of java code that can generate database
GUIDs.
ciao,
Menon

I'm looking for an efficient way to pass data from java 1.3 (and above)
to oracle 8.0 (and above).
I've tried 2 mechanisms already but I'm not really happy with the
performance of either:

What Oracle cd has "SQL*Loader" on it?

we use UTL_FILE to read files in our PL/SQL Program.
Today we got an exceptional file, which is greater than 2 GB.
our program failed with the error as:
SQLCODE <-29284> SQLERRM <ORA-29284: file read error>

It's easy enough to set up a WebDav connection on XP (map network drive to
http://127.0.0.1:8080), which nicely prompts for the database credentials.
But I can't find any references to disconnecting and reconnecting to another
database account.

Hi, all.
I'm running 8.1.7.4 on AIX 5.2.
I am trying to get my RMAN to include the date/time in its output
filenames. It is not working.

I have two databases 9.2.0.5 (AIX)
with exactly the same table dvordtm
- on the first DB, CTAS give me
NOT NULL constraint