I asked aunt google on this but didn't come up with a defintive answer, so I
thought I asked the gurus.
Our customer has two databases on two servers. Each database has two
schemas, both using their dedicated tablespace. The schemas are named the

I have successfully installed 9i DB and would like to install the
developer tools so as I can develop my skills and hopefully take the
exams! However, when I install the tools (in a different home
directory) the installer asks me to set up my directory service.

We often use alter session set parameter_name=value, to tune some
specific SQL.
But for example we have such a case:
select a.id,b.name from a@dblink ,b

I am creating a package for Oracle 8i.  I need to pass a variable in
and use that in the SQL statement IN clause.  This worked for a simple
equal statement but not for the IN.
'select * from CUSTOMERS where CUSTOMERS_CODE in (:x1) ' USING IDS;

This script came from a Sybase db and now it needs to be converted to Oracle
10g.
I keep getting an error that "totalcount" is an invalid identifier. I found
in Oracle's docs

is there a way in oracle to get the name
of the calling procedure?
Example:
==========================================================

I would like to know the minimum permissions required to use failsafe in an
Active Directory environment.
Is there any documentation available describing how Failsafe is reliant on
security or other mechanisms e.g. DNS in Active Directory?

we have a single cpu Oracle 8i EE license. We need to migrate the
database to a new box which has 4 cpu's. Is there a way to limit the
usage of oracle 1 cpu so that we are not in violation of our license.
Any help or pointers on this issue will be very helpful.

I have searched high and low for an answer to this, can anyone help?
I am writing a BEFORE INSERT trigger on a table with a calumn called
COMMENTS which is of type CLOB. I need to assign a value (another CLOB
from a different table) to :new.COMMNETS - but I understand this is a

How can I reduce the roundtrip of an sql statetement exectution ?
I look at some documents that talk about set array size on sqlplus...
and It works.
But if I have a C++ aplication that is executing the statement.. how can

Is there some way to FORCE SQL*Plus to always return a figure for the
number of rows selected?
It doesn't always return the number of rows returned.
For example if I do:

I need to build a large query that uses the subquery I created. I know
there is a way to name the subquery so that I could pull the name of
the subquery and the constances in it. It's just nor working properly
at the moment. Would you mind take a look and let me know?

Hi. I'm relatively new to plSQL, and I have a bit of a problem. I'd
like to make a package with one procedure creating some tables, and
another procedure SELECTing from them.
Is this even possible? My problem is that (as far as I know), plSQL

Hi Everyone,  I'm in the middle of debugging a VB app that calls a stored proc.  The stored Proc checks tables and under certain conditions copies records to another table.  Depending on where I run the stored Proc from I get a different number of records copied.
VB  - 0 records ...

Hi Everyone,  I'm in the middle of debugging a VB app that calls a stored proc.  The stored Proc checks tables and under certain conditions copies records to another table.  Depending on where I run the stored Proc from I get a different number of records copied.
VB  - 0 records ...