Which tool can view the table and delete rows by condition?

Question

Oracle

The table has a date field. What tool (function) can view the table and delete rows with a date less than the current one?
I don’t want to make external queries to the database, I would like to implement everything within the framework of the database so that it independently checks everything.

Answer 1

Well, a job is ideal for your task - arrange the tasks you need in the form of a procedure and pull it as often as you need