Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check expiry date in Oracle SQL?

540799Nov 21 2006 — edited Nov 21 2006
Hello,

During setup my OID database, I have a one question rise . . .

I've two field in my table. Sample_table1(id varchar2, expiry_date)

Now I want SQL query or Procedure whcih check current date and compare with expire date. If expiry date is gone than it delete that id from table.

So, simply, I want a query which select those id who expired from current date.

Reply me asap. Thanks a lot . . .

Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2006
Added on Nov 21 2006
#general-database-discussions
1 comment
1,360 views