I have a table in oracle with information similar to this:
city code
A     XX
B     SS

We have Oracle 10g in HP-UX. We need connect to SQL server 2000 in
Oracle environment. I download ODBC drvier from datadirect and
installed it in HP-UX. Everthing looked fine. The problem is we had to
pay lots of money for ODBC license fee.

I've been tasked with tuning a particularly offensive query (8.7.0.4 on
AIX 5.2). We're still using the RBO in all cases. CBO is also on my
task list. ;-)
We have a Production environment, and a test environment, which is

Anyone running 10g in a cluster environment?  I'm trying to decide between
AIX or W2K3 for my cluster.  Any tips, advice, horror stories, etc..  
Appreciated.
Thanks.

I'm trying to append data from a VARCHAR2 field to a LONG field in
PL/SQL.  Can I use AppendChunk to do this?  I can't seem to find
examples about how to do this.

I have been writing SQL scripts for five years, however lately,
the database I have been working with is so large that
queries I need to run are taking in excess of hours.
I have been reading the Oracle literature on DB and SQL

Before you start flaming me please pardon my ignorance. I am about a
week old in Oracle. So far, I have successfully installed Oracle 9i in
a RHEL 3.0 server and Oracle 10g client in Fedora 4. In my server
lsnrctl start and dbstart works alright and has a service activated.

ORACLE APPLICATONS 11i TRAINING FROM US RETURNED PROFESIONALS
·      Oracle Financials 11i
·      Oracle Applications - Technical
·      Oracle Applications DBA

I have been trying for some time to install a .NET application, and
finally succeeded by changing the default Oracle Home.  How can I tell
.NET to use a specified Oracle Home, without having to make it the
default?

Hi, all.
I'm trying to get rman working for the first time, and am coming to the
end of my rope.
Background: My catalog is on 9.2.0.4. I want to connect to an 8.1.7.4

We migrated a database from 8.1.7 to 10G. We still have the roll-back
tablespace (and also the undo tbs). Is it save to take the roll-back
tablespace offline and delete the datafile? In the DBA_ROLLBACK_SEGS I
find only records with the tablespace_name SYSTEM and UNDOTBS1.

Is there a way to check in PL/SQL if a stored procedure exists?
Alternately, how can I catch the error when a stored procedure doesn't
exist?
Thanks for your time

ORACLE APPLICATONS 11i TRAINING FROM US RETURNED PROFESIONALS
·      Oracle Financials 11i
·      Oracle Applications - Technical
·      Oracle Applications DBA

Please correct this SQL which is returning multiple records.
SELECT DISTINCT a.CALL_TIME, a.P_TRANSID, a.METHOD, b.CALL_STATUS, FROM
DT_IPOS_CALL_LOG a, DT_IPOS_CALL_STATS b WHERE a.P_TRANSID IN (7569302)
AND a.P_TRANSID = b.P_TRANSID (+) ORDER BY a.CALL_TIME

I am porting a program from Ms Windows to AIX 5.
The program is written in C and uses Pro*C to access the
oracle 9.2.0 database. The program also uses OCI for
updating BLOB to the database. On the Ms Windows,