Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting Specific rows from a Table
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, RussiaReceived on Mon Sep 17 2001 - 02:19:08 CDT