Re: Deleting Specific rows from a Table

From: Reid Lai <reidlai_at_netvigator.com>
Date: Fri, 14 Sep 2001 00:18:32 +0800
Message-ID: <3BA0DC58.23C053B8@netvigator.com>

8i supports dropping column. What is your version?

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
>
> Barry
Received on Thu Sep 13 2001 - 11:18:32 CDT