Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Help Plz
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