What is the norm when a front-end programmer (e.g VB) designs an interface for a database (e.g
Oracle)?
Specifically, I mean should the front-end programmer hard-code constraints like null/nullable fields
into his/her interface, or should he/she just output the meaningless Oracle ...

I need to a way to search for a specific word within a field using a
CASE WHEN command within the SELECT section of an SQL query.  For
example, let's say the field looks like:
'234234-Greg-325123616-1341436-234324-43-Don-235161436-2436-2346-435'

Our database has a table of types. I can do a select from the table,
making a restriction on the fields that are on the type.
i.e. my table of 'trades' has a reference to a sub_trade type. I want
to query my trades where the sub_trade type has a particular id. I can

Can we replace null values with banks in the external table instead of
spaces?
'missing field values are null' replaces with nulls.
any ideas?

Oracle 9.2.0.6 EE WIN 2K
I have a query against a large table (18 million rows) which contains 2
WHERE clauses.  These columns form a composite index called
PSDTL_PAYABLE_TIME(DUR,TRC).

I am trying to get 2 listeners working on the same machine, each using
a different timezone.  I know this can be done on Linux/Unix boxes but
I can't seem to get it to stick on a Win2003 machine.  I want my
original listener (port 1521) to use EST time and my other listener

Fact: Oracle (all versions) and FC5 are completely incompatible because
of the new
glibc. When ones enter "FC5 Oracle10.2" into Google, the first thing
that pops out

I have a standalone oc4j (10g) installation on Solaris 9 and when I run
my servlet (which instantiates another class that uses native code), I
get an java.lang.UnsatisfiedLinkError even though the native library is
on the path specified when running the oc4j instance using

Hello.  I have a simple script, but I want the script to alter it's
behavior depending on whether it's being run against a 10, 9 or an 8
instance.  The patch level doesn't matter.
I can use V$VERSION and parse the output:

I hope I am posting in the correct places.  I am looking for some help that
is hopefully explained in the example below:
I am looking to create an object relational database with a check constraint
on the relationships. For example:

Can we replace null values with banks in the external table instead of
spaces?
'missing field values are null' replaces with nulls.
any ideas?

I tranfered a schema from 10.1 to a 10.2 database
I got 2 problems I did'nt understand:
- how can I have NULL value  with constraints valided ?
- why some value are too large in the 10.2 database ( same charset

I have a problem using XMLTYPE in the case that I have multiple tags
with the same name. example:
<tag1>
   <tag2>str1</tag2>

I get this error from the following line... Can anyone tell me why???
colvalue number;
mcn varchar(100);
lotid number;