want to ask a question...
Currently we use Informix 9.21 on Windows platform and planning to
migrate to Oracle 10G.  I downloaded OMWB program from Oracle...
Created oracle database with character set , migrated one database

We have core application and customer specific application "inherited"
from the core application.

classes to do it.

i'm a newbie, i'd like to guess if anybody knows how can I upgrade my
oracle 9.2.04 to 9.2.05.
My java_pool_size, shared_pool_size are under 150 MB. How can I set
this value?

running  9.2.0.4.0 on Sun Starfire 15k Sun OS 5
tables have 36 partitions on DT_REV_MB_YYYYMM column in both tables
have the following query (note the line   a.DT_REV_MB_YYYYMM  in (200505) )
and it does one partition per table

I am trying to connect to Oracle database using OLEDB for Oracle but I
got error "ORA-01008: not all variables bound".
The following is my code:
string  conString ="Provider=MSDAORA;"+

I need to know if it is possible to build a 3 dimensional table in Oracle.
By 3-D, I mean instead of the standard (x,y) reference to a cell (row,
column), if it is possible to subscript the cell (x, y1), (x,y2), etc.
Thanks,

Oracle 9IR2
I have created a table, and if I explore it via Toad, it looks good.
However, I'm getting strange results from all_tab_columns:
SELECT COLUMN_NAME FROM ALL_TAB_COLS

I wonder if anyone has come acrossed this problem, I have a trigger
like the following
CREATE OR REPLACE TRIGGER AREA_TRIG
BEFORE INSERT OR UPDATE

Platform: Oracle 9ir2 on Solaris 9
Hi folks what is the easiest way to do this?
We are using UTL_HTTP.REQUEST_PIECES to retrieve whatever is at the end
of a URL. This may be an HTML doc or perhaps a PDF or MS Word doc.

I created a TEMP table with the following fields.
Study  varchar2(20)
patient  varcgar2 (10)
site       Varchar 2(10)

I have what I hope is an interesting opportunity. My company is about
to put me on a project to optimize an oracle application. I have some
ideas, but I am not actually on the project, so I can only guess on
certain parts of it. I do know it is currently on 9i, on a Sun machine.

RDBMS : 10.1.0.4
OS    : Linux Debian Sarge 3.1
Kernel: 2.4.27-1-386
Box   : standard office PC with 1G RAM

All,
Kind of a new person here and this may be a stupid question but.
We have a table with 20 columns and many millions of records.  I need to
check if the combination of 5 of those columns exists anywhere in the table.

I have some problems using functions that returns resultssets.
I have a package looking something like this - I have removed the actual
fields,tables and conditions  to simplify it:
CREATE OR REPLACE package StatView as

Is there any function in Oracle which can yield the MD5 value of a string
just like the MD5() function of MySQL?