Given a table, is there a way, using SQL, to figure out,
which columns are part of the primary key?
Given two tables, I'd like to create the "on" condition
of a merge statement.

I just received the assignement to make a batch 'go faster' on Oracle
9.2.0.5 and AIX 5.
To summarize this batch does :
- take a file on on machine to fill a temporary table(size between 100K

I am trying to build a query that can update empty date-fields in my
db-table.
I have no problem retrieving entires where date field is not empty,
with the following query:

I have a test database with many columns  Name1, Name2 .............and
so on. Set out as follows:
Name1                           Name2
............................

A monsterous problem beside setting ALTER SESSION SET
CURSOR_SHARING=EXACT;
if you recieve no rows returned a function and are wondering why - this
maybe it. In our environment we Oracle 9.2.0.5 and using VARCHARS in a

Can someone give me a few pointers or direct me to a URL where I can
find the steps involved in storing tns entries in OID? I've looked at
the OID 10gR2 admin guide but was unable to find any information in
there. We are running 10g Application Server Release 2.

How can we convert 20060321T13:53:28671 into date format

does anybody know a way to log when a user account is locked out? For
instance when reaching FAILED_LOGIN_ATTEMPTS limit. The version is
8.0.6 (I know it's not that new..) I have searched documentation and
forums, concerning eg auditing and system triggers, but without

First things first - I'm very new at Oracle!
I have installed Oracle 10G XE on an XP Pro computer & have created 3 blank
tables using the web GUI interface from Oracle. All fine so far. My next step
is to fill the tables with data via VB.Net.

I am an Oracle newbie and could use a little help, please.  We are
porting an app to Oracle that already runs with Ingres and MSSQL.  Our
UUID (GUID) columns are stored as RAW(16).  I would like to write a
function that will convert the 36-char (or 38-char) GUID string to

I need to connect an Access (probably 2003) to an Oracle 9i db. I will
have readonly rights on the Oracle db. (just need to place the data
from oracle into access, no updates necessary from access to oracle)
I'm aware that i have to use ODBC drivers to connect, but are there

I desperately need help. I need to do a simple query of Oracle 9.2.0.7
database from either C or C++ code on Solaris 10. I have very limited
experience with either Oracle or Solaris but very extensive experience
with C/C++. I first tried to build Oracle sample program cdemo. I seem

I've been trying to get DDL auditing to work on a test database.
I've changed db_audit=db parameter and bounced the db.
system@TEST> show parameter audit
NAME                                 TYPE        VALUE

Is there any place I could find a logfile user requests to the database ??
Regards,
Laurent.

I would like to create a mail client for Oracle Forms. To send an email I
use UTL_SMTP, and it works fine, instead to receive an email, I'm not able
to find any Oracle package.. Do you know if exists some kind of package that
permits me to receive an email using telnet commands, ...