Re: What can I have to auto date inserting?

nick_at_spbgtw.pczz.msk.su ("Nick Maximov") writes:
:
: What can I get a date of last table updates in Oracle RDBMS?
: I should like to select a new rows inserted or replaced after interesting
: dates. Is this exist as special column (as ROWID for example)?
: But what can I do to automatic current date inserting?
:
: Thanks in advance to somebody who forward me a SQL query example.
:
: Nick Maximov,
: St.-Petersburg, Russia.

1. Create a column in each table, last-accessed.
2. Create an on-validate-record trigger, that will select the sysdate into the field when you have a new record.
3. Add a pre-update trigger to select sysdate into this field before update
4. You would not want to change this date when you query this record.
5. If you name the field the same in all of your table, you will be able to copy procedures and triggers.

                This will work in Ver 6 of the RDBMS and Forms 3.0

																							Howard E. Kennedy

	

P.S. Your e-mail address bounced my reply to you back.
	Send me your correct e-mail address

-- 
Howard E. Kennedy uucp: ...!uunet!rde!howard  inet: howard_at_vistachrome.com