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: TurkBear <noone_at_nowhere.com>
Date: Thu, 13 Sep 2001 11:42:33 -0500
Message-ID: <3do1qtst8f00ophttr2t3qdel4d6h4971q@4ax.com>

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

Original text of this message

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