I met a strange dead lock on clob column.
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

I was wondering if someone would shed some light to the following
question, described as follows:
Transaction 7 begins
time passes

I have a Customer Master table and have a child table for multiple
address of 1 customer. In the Address table have a column for ActiveYN
which is 'Y' for only one record. I want to get a view with the
ActiveYN = 'Y' address by joining these 2 tables. And also need a

I have a number of questions regarding the installation of Oracle 10g
Express on a pc.
Does anybody know the processor requirements to run Oracle 10g
Express on a Windows

I have a number of questions regarding the installation of Oracle 10g
Express on a pc.
Does anybody know the processor requirements to run Oracle 10g
Express on a Windows

There was a change in 10g in how the tablespace % full alerts trigger
and get cleared. It began being handled by the DB itself instead of the
EM agent. Here's my question. When you set warning and critical
thresholds via grid control for a 10g database, shouldn't that set the

Hello Group
                    Excuse the blast please.  I am seeking an expert
opinion in Migrating data from an existing Oracle RDBMS to another.
The existing system is proprietory and can be accessed only via a JAVA

Please, download our Books (John Sakellaris, Serban Vlaud, Nikos
Mastorakis, Olga Martin)
from the site:  www.wseas.com or www.wseas.org
Our Books are Free and available for everybody. If you find them

what is the simplest way of inserting a file from a client to a blob column
using SqlPlus ?
Regards,
Maija-Leena

I'm trying to move my Mssql database to oracle. I had read that Raw database
is the equivalent of uniqueidentifier (GUID), but I do not see it in 10g
express Edition.
There is any other equivalent or any other way to do it.

We use 9.2.0.6.
We have a 'problem' to execute an update command like
update <tablename>
set expression=

please consider the following query:
select 12*sal yearly, yearly+comm
from emp;
I would expect that the alias can be used in the next output field of

I have a query:
SELECT GROUP_NAME, PERCENT FROM GROUPSUMMARY
WHERE REPORT_DATE= TO_DATE( '2007-10-01','YYYY-MM-DD')
ORDER BY PERCENT DESC;

hello, my database has been shudwon.
i would like to connect to my database(taping sqplus connect/
asystem............. ) it, but i have 2 errors :
- ora-01034 : oraclenot available

Any ideas about the practical (and working) way of exposing the result
of pl/sql functions as webservices?
A function would look like this:
function something (par1, par2) return some_table_type, so that the