I have two tables t1 and t2 containing 10K tuples each. I tried to do a
non equi-join on these tables using the following query.
select /*+ ORDERED USE_MERGE (t2 t1)*/count(*) from test2 t2, test1 t1
where t2.a > t1.a;

select region, issue, decode(value,'y','yes','n','no','--unknown--'),count
(value) val_count,
from data
group by

I have a problem with a table whereby everytime a record is created
another is created showing the opposite of this:
e.g.
Rel_Id (PK)|Source_Id|To_Id|Start_Date|End Date

Is there a way to sort an alphanumeric column in this order?
Basically, I want to ignore the alpha characters:
.2
.4

is there a way (using oracle functions) to find last occurance of
character w/o writing a recursive function?
e.g. select XXXX('ooozo','o') from dual
would return 5

ORACLE APPLICATONS 11i TRAINING FROM US RETURNED PROFESIONALS
·    Oracle Financials 11i Functional
·    Oracle Applications - Technical
·    Oracle Applications DBA

We're using an Oracle 9i VPD to control security.  The VPD allows
modification of the WHERE clause, but is there any way to modify the
FROM clause also?
If we are only able to modify the WHERE clause, we will be forced to

I hope this is an easy question.  At any rate I need to upgrade from
9.2.0.4 to 9.2.0.5.  I'm asking becuase I've intalled patches before
but never changed release numbers and I don't want to screw anything
up.  Is upgrading to 9.2.0.5 as simple as loading the first 9.2.0.5

Is there any way to list the files created by UTL_FILE in a directory
created using the 'Create Directory' command using pl/sql?
Thanks,
Neil

Someone knows the answer maybe ? Is it somewhere at the OS
level (like for 8i/9i OEM events), or is it in one or several
tables of the repository ? If yes, which one(s) ?
Thanks.

We're about to replace 20 Unix systems. New hardware includes a SAN.
Upgrading to Oracle 10G (mostly 1, but 1 host might have 15 instances)
is part of the project. None will have 'high performance' requirements.
Database sizes are in the 10 - 50 GB range. Ease of admin (both at the

ORACLE APPLICATONS 11i TRAINING FROM US RETURNED PROFESIONALS
·    Oracle Financials 11i Functional
·    Oracle Applications - Technical
·    Oracle Applications DBA

Is there a way to compare data from two row (current and next row) of
data in Oracle by just one SQL statement?
I have a table looks like this
f1                  f2

I've got a problem when linking our program against Oracle 8.1.7.
With previous versions of Oracle we used to compile with static
libraries. I tried a lot of things, of which I will show some attempts.
The first lines mention the used libs, followed by the errors I got.

I've been requested to move all of our DATE columns over to timestamps
as the Java date object does not have a time element, when a query is
thrown to the DB and this selects a date column, the time section is
automaticallly lost via