any refernces how to install AQ - is there any need to do anything to
listener..
All links appreciated...
rgds

I know this question has been posted many times and I have gone thru
all of them and tried using decode also.  But I am still not able to
get the desired output.  Here are the details.
I have the following table

I just try to update DATE field by add  n * 365 by a stores_procedure,
but
after run the procedure, the date field becomes NULL. I don;t know why?
I have tried on  Oracle 10.1 and 10.2(XE)

If the EXECUTE IMMEDIATE mysql USING bindvariable1,bindvariable2 knows
what to fire - surely there must be a way to capture the actual
statement that it uses.
Note:  I realize you can step through to obtain the bind variable

We are using transactional global temp tables to handle complex queries
in stored procedures. Is there a way to improve performance with the
temp tables?

I need to compare two dates...one stored in a table and the other user
generated.
The table column time is of the format 08/03/2006 07:31.
The user generated time is 2006/03/08.

I've noticed a colleague computes histograms in a schema against
all indexed columns of this schema's tables, with no regard as to
whether it's relevant or not (they're computed on unique values as
well), and with only 2 buckets everywhere.

This code is far too slow. Can some show me some code to speed it up.
Many thanks.
-- PL SQL CODE
--------------------------------------------------------------------------------

Hey All,
I'm trying to understand the 'partition by' clause.  I'm reading a
bunch of webpages and they are showing examples and all.  But when you
come across say a function like SUM, you can easily form a mental

(8.1.7.4)
I have a 6-table query that's pretty slow; I've managed to enhance
its response time with hints but when I check what the optimiser
does without them, it only goes through 215 combinations to join

I have simply select with ORDER BY like
SELECT x FROM y ORDER BY z
Oracle (version 10.2) does not use index despite of there is index on
column z. There are many records in table so SELECT takes long. Of

I am a *reasonably* competant engineer when it comes to DB's but I am
not expert. I can write stored procedures, do the basic SQL querying
etc. However I am not an expert and I *need* to become expert
quickly... I work freelance in finance. In order to jazz up my CV I am

Hi everyone, I have a table that contains duplicate records.  All of
the fields in these records are duplicates except for the primary key.
I need to identify these records by their primary key.  Can anyone help
me with this?  Thanks ahead of time.

I'm currently testing the effectiveness to switching some heap tables
to IOT's.
The primary goal is simple: REDUCE IO.
My environment is 10.1.0.4 on Solaris.

I have noted too many threads in the Task Manager related to the
ORACLE.EXE
process for 10.2.
So I run a simple testcase program on a test server with no activity