When one executes a query with OCIStmtExecute, is there a way to tell
the *number* of rows affected by the statment? Can an example be
provided as to how to get the number of rows affected by an insert /
update or delete statement executed through the OCIStmtExecute?

I seem to be able to connect locally using `sqlplus lee/$password@lee3
using SQL*Plus, but I get the following error when I use iSQL*Plus:
   ORA-12162: TNS:net service name is incorrectly specified
I've seen plenty of similar posts on Google, but none of them have shed

I have a very big table with 10 million transactions, that contains
information about our sales (items, quantities, amounts, etc).
We run a lot af big (slow) querys, to get sales information.
A query could look like this:

I don't have all the details on this, but I'm putting this out to the
world in the hope someone sees a positive way out.
I have a customer who has two CSI's.  This came about because they
bought a database EE development and runtime license for Oracle through

I just installed Oracle 10g. On one of the installation screens, I
unchecked the box prompting to 'Create a starter database'. Later,
after the prerequsite checks, a screen appeared with the title 'Select
configuration option' with the following options:

I have procedure that calculates values and pupulates them in a table
nightly, once a day. I was asked to come up with a sql statement that
will compaire entries from today's run and previous night run. I can
write a plsql proc, but thinking about LAG() and need your help.

I have the below MERGE command with a decode function as part of the
select clause.Irrespective of the data, the value of column
ABND_ELEC_PYMT_FEE_IN, always evaluates to a 'N'. once the MEREG
command runs successfully.

Here is my problem:
node1:
select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER

I'm really interested in the XML Publisher product mentioned here:
http://www.oracle.com/technology/products/applications/publishing/index.html
I can't seem to find where to download an eval copy of it, though.  I
don't see it listed in Oracle's download page, and I'm not sure what

I'm really interested in the XML Publisher product mentioned here:
http://www.oracle.com/technology/products/applications/publishing/index.html
I can't seem to find where to download an eval copy of it, though. I don't
see it listed in Oracle's download page, and I'm not sure what ...

Last summer I had a hardware failure on an Oracle server.  We fixed the
hardware problem and lost our Oracle install in the process.  One of my
Oracle db users had his own database on the server and in its own
tablespace (unfortunately he wasn't doing backups).  Once I got the

Hello all, i am new to oracle, i just know how to install oracle on a
windows machine. I donot know how to install and setup oracle on a
solaris server. I have been assigned to setup oracle on a solaris web
server. For my intial start can any one please tell me what all the

At what point should a reorganization of a table be considered?
I have a table that has 48 extents, and two indexes of 77 and 23
extents each.   The time required to read this table sequentially has
dropped significantly recently after many new rows were added.

I have this query which filled up 12GB of temp space.  tableA has 500K
records where tableB has 5M records.  sid are indexed.  The 2 tables
combine only 200 mega bytes and yet this query needs more than 12GB of
temp space to perform.  I am thinking it's the multiple group by that

We've got an application which runs concurrently,
So each app identifies its data by having the session id in one column.
(We can't use temp tables because we use oracle spatial.)
Now, sometimes that app dies and leaves data in the table.