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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Help Plz

Re: Newbie Help Plz

From: Anna C. Dent <anacdent_at_hotmail.com>
Date: Sun, 02 Nov 2003 18:07:03 -0800
Message-ID: <bLipb.107362$Ms2.85211@fed1read03>


Mumblez wrote:
> could someone please tell me how to remove a record that is past the present
> date?
>
> for example if you have users that have an expiry date what sql command do
> you use to check the date and then remove that record
>

DELETE FROM TABLE_A WHERE EXPIRATION_DATE > SYSDATE; Received on Sun Nov 02 2003 - 20:07:03 CST

Original text of this message

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