Re: DELETION PROBLEM

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 01 Sep 1998 21:29:07 +0200
Message-ID: <35EC4B02.18167F1C@sybrandb.demon.nl>

change it in
delete x
  where upper(substr(CLLI,1,4)) =

                       (select  upper(y.CLLI_NAME) from <table_name> y)

 /
and it will work
Hth
Sybrand Bakker, Oracle DBA

Sreenivas wrote:

> Hi
> delete x
> where upper(substr(CLLI,1,4)) =
> upper(y.CLLI_NAME)
> /
>
> X AND Y ARE TWO DIFFERENT TABLES.
>
> Can you give the condition like this in delete statement.?
>
> If not possible solution?
>
> Thanx
> Srinivas
>
> :
Received on Tue Sep 01 1998 - 14:29:07 CDT