Help, please.
I have to query a table to trim a certain field, and to catch its
certain substrings. The tool I know is like ltrim() or rtrim(),
something like

I need to cross tab some information that looks like this:
UserPermission UserGroup Enabled
100                   1               Y
100                   2                N

Can anyone tell me what the difference with the keyword 'IS' and 'AS'
when used after the declaration of the procedure of function.
Example:
CREATE OR REPLACE FUNCTION(val VARCHAR) RETURN VARCHAR2 IS

I am using Oracle 9.2.0.5 on HP UNIX 11i. It is a production system.
Following error occurs:
ORA-21503: program terminated by fatal error
ORA-04030: out of process memory when trying to allocate 32768 bytes

In the context of a discussion of when to upgrade to 10g, one of our
network administrators asked when Oracle 11 was coming out and if it
would make sense to wait and skip a version.
After on hour on google, metalink and Oracle's site, I haven't been able

  I  have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for
window version 32 bits,
does anyone can provide the node document information of step by step
doing it.

In his book "Expert Oracle Database Architecture", Tom Kyte describes a
method for generating uptime reports for an Oracle server.
This section of the book is reproduced on the web here:
http://www.dbazine.com/oracle/or-articles/kyte6

I'm sure this is fairly simple but I need help speeding up a query
which is taking far too long to run.  I'm joining 2 tables and
retrieving a single value.  I would think a proper index(es) would
solve the performance issue.

Can someone please show me how a select statement in for an Oracle DB must
look so as to only select those rows which have been inserted or updated
since a given time? For example, If I have a table 'table,' and I want to
select all fields of a given row in table which have been ...

i have a test table in oracle. The two columns are START_DATE and
START_TIME.
START_DATE is stored as 16/03/2006  and START_TIME as 55000.
I need to concatenate the start_date and start_time and i need to

Gentlemen,
I'm trying to bind a simple array of integers before an INSERT
statement. I  guess something in the documentation escaped my
attention, because I'm unable to make the bind. For exemple, on the

Hello. I'm trying to get a 2-node RAC installed and I'm having some problems
with the listener starting on either node. I know the listener is dependent
on VIP and that appears to be working correctly. What is the best way to
validate the VIP is working before running netca? Both ...

I'm looking for information regarding multimaster replication in Oracle
10g. I've found out that asynchronous replication would suit our needs
well. The exception is the data conflict that occurs when two users at
the same time creates a new record in the exact same table in their

I am testing Oracle
I have small table (76,000 records). I have index on one column. I am
testing 100 queries which use this index (WHERE indexed_column =...) I
am using also utbstat and utestat statistic. and I see that my 100

I have recently installed Oracle 9i server on a Windows 2003 Server machine,
but have had great difficulty in getting the TNS Listener to run as a
service.
Despite verifying in the Oracle Installer that the TNS Listener is indeed