Hi Sql users :
I have a question for writing a Sql query.
I have a table with several fields including a date field :
e.g. Table1
fld1 fld2 .... .... ..... code dateo
[data] .... ... .. 10 01-mar-93
... 60 10-oct-93 and soon
I have created a similar table ( tablehist ) with same fields to keep an
archive.
I would like to grab the records from table1 between sysdate ( today )
and 3-months old ( from today ) based on dateo field in table1 and
based on code = 'xx' and insert those records in tablehist data.
I would like to delete those rec's from table1 in same code .
Can I associate a trigger in a form to do this task!
The sql code should run on any given day.
Any ideas and help would be appreciated. Please post on this group.
Thanks.
