I'm very sorry if this is not clear, but it is complicated to me.
basically I am not sure if what I want to do is possible in sql, and perhaps
if it is someone can tell me how to do this.
I'm working on a where clause that gets used by a process.

Hi does anyone have any statistics on the largest Oracle data warehouse
in terms of total data, as well as the warehouse with the most known
concurrent users  ?
Thank you,

I am new to using LOB data types.  Could anyone double confirm if my
understanding of the basic concept is correct.
1. When I declare a variable of CLOB type and init it with empty_clob(),
only a locator is declare.  There is no physical storage area allocated.

Does exist PGP library to use in PL/SQL code (PL/SQL package, java stored
procedures or java library loaded in Oracle)?
thx,
   M.

Platform: Oracle EE 9.2.0.1 on Solaris 5.8
Yesterday I recieved a string of forwarded emails from one of our dev
managers.  I was asked simply "What does it take to upgrade the
database driver from 9.2.0.1 to 9.2.0.5?"

I am trying to create a function based index to speed up a query, but
the index doesn't seem to be used.  The user defined function is based
on a java stored procedure, I'm not sure if that could be the problem?
Also, the function is not owned by the user creating the index, but the

I have just started a new job which was supposed to involve tuning some SQL
& PL/SQL code on an Orarcle 9i database; however it seems that I am also
supposed to be the DBA for this database (with the exception of backups
which are apparently done by nameless persons at the site ...

I have an intersect query that takes about 48 seconds to return 93
rows.  This is on 9.2.0.4 on Solaris.
Select distinct e_id, p_id
from some_view

We are running 9.2.0.4, two instance (and two node) RAC on Win2k3
Server EE.
I have a TAR open for another issue (RMAN jobs scheduled through OMS
are completing per "jobout" log files on target node, but OMS never

We have the following query:
SELECT w.WELLS_PK, w.WELL_ID, w.PLATE_FK, w.SAMPLE_FK, w.REACTION_FK,
wam.WELLS_AMPLICON_MAP_PK, a.AMPLICON_PK FROM   CL_WELLS w,
CL_WELLS_AMPLICON_MAP wam, CL_AMPLICON a WHERE

Group,
I searched through the archives and there seems to be a solution to my
problem, but no one ever states what it is. I'm confident from what
I've read that this should work, but it tells me that the select

I have writen a procedure that logs certain events and I want call the proc
from other procedures, from functions and from triggers.
something along the lines of :
Insert into Logtable

Dear Friends,
Can anybody send 1z0-040 dumps?
Thanks & Regards

Please advise on how the Hot and cold Backups will help me in the
following Scenarios
Suppose i have taken a backup on MONDAY of datafiles, control files,
archive files and redo log files ( i know it is not advisable to take