Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting Specific rows from a Table

Re: Deleting Specific rows from a Table

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Mon, 17 Sep 2001 11:19:08 +0400
Message-ID: <3BA5A3EC.49F39EEB@bill.mts.ru>


Barry wrote:
>
> Hi..
>
> I have the following sample table:
>
> Account1 varchar2
> date1 date
> name1 varchar2
> date2 date
> name2 varchar2
>
> I want to be able to delete date1 and name1 from the table under a
> specific
> account but retain name2 and date2. I have looked through Oracle
> documentation and I get the impression that this cannot be done. If
> you have any ideas it would be greatly appreciated. Thanks

   Atomic part you can delete is table row.    You can't delete partial field(s).

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia
Received on Mon Sep 17 2001 - 02:19:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US