i've got a procedure which is supposed to return a ref cursor but also
the sum(field1) from the cursor.
The select statement is quite complex (and will probably be dynamic)
and I assume it would be better to do this once rather than twice. In

How to extract the records of same datetime from a table?
I have a table 'tbl' with datatime column 'call_time'. there is no
unique constraint or primarykey.
How can I extract only the records of same call_time values?

Would like some comments on how you would tackle the following.
2 nodes running Oracle SE. One to serve as primary and the other as a
standby for HA.
Application - batch process (daemonised) doing close to real-time

Hi. I've got an Oracle stored procedure with a
user defined output parameter my_array_type:
describe my_array_type;
 my_array_type TABLE OF VARCHAR2(30)

I currently look after an Oracle 8.1.7.4 database instance running on
Solaris 7 which is replicated with an identical database instance at a
remote site using Oracle Advanced Replication.
For a number of months now the database instance has been periodically

I opened two session, one to query data, and one to query v$sesstat to
monitor session one's statistics, and I set the arraysize to 1 in
session one, and got the following result:
Session 2

i need to set up some TEST replication from our main database to a
database set up on remote test server.
before anyone jumps in and says "READ THE MANUAL", i have. i have also
had a look through the OEM GUI wizard as well :p

I have the following code:
=========================================================
PROCEDURE upc_reuse_gen_upc_list_p (vArray_size IN PLS_INTEGER DEFAULT
100) IS

I was planning on buying one when IBM themselves cast some doubt on
whether it would work.  Would like to do RAC with 2 computers, and I'll
be running 10g on Redhad Linux for AMD64.  Any advice appreciated.
Thanks

A question on direct I/O: Does direct IO mean bypassing the Unix buffer
cache and going to DB cache directly while IO or does it mean bypassing
DB cache and writing/reading from PGA to/from disk?
When using filesystems in Unix boxes is the cache for file systems

We have two node Oracle 9.2.0.4 Enterprise Edition cluster in Red Hat AS
2.1.  Both the instances that are in those servers read/write to
OCFS filesystem in SAN.  All the hardwares are Dell.  Whenever a OS command
that does both io like cp,  mv, tar, gzip etc. is run the CPU

I have a script that needs to read the longitude and latitude values
out of my database, the result of this query needs to be dynamic as it
is used to build mapped locations in Oracle Spatial. I just can not
seem to get the values of X1, Y1, X2, Y2, to be passed tothe array. Can

Plans are to expand an existing warehouse. Oracle will be too small
therefore the new datawarehouse will be built on
Teradata.
Is it possible to move a Oracle data warehouse snowflake model to

Hello users!
I have to prepare a paper about ERDish programming language. Unfortunately I
can't find any useful info about it.
All I know it is connected somehow to Oracle database  Any idea what's that

Is it possible to use Dynamic SQL in Oracle as in SQL Server2000?
I used this
declare t table(i integer, n varchar(10));
insert into t values(2,'dfg');