Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting Specific rows from a Table
If by delete you mean eliminate the data in those fields, then update table set date1=NULL ,name1=NULL where Account1='whatever' will do it..
btaller_at_vailtech.com (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
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Sep 13 2001 - 11:42:33 CDT