LOG LOG LOG....

 Hi all,

Well this is my first post for ORIXoom blog and i am going to advice all my peers that in your all tables specially the masters tables always give following columns

CREATED_BY .......The User who created the record
CREATED_DATE ......Date of Record creation
MODIFIED_BY......Last User who modified the record.
MODIFIED_DATE......Last date of modification in the record.

And if you can afford then always try to log deleted records in a log table. May be provide option of Logical deletion in tables for example table structure similar to this

e.g
Emp_Cd number,
Ename Varchar2(120 Char),
record_is_delete varchar2(1) defaults to N which means Record is active in database........stores Y when record is no longer needed.....

believe it or not this would definitely save u from trouble some day.

Dont forget to visit my personal blog also

Cheers,
ZB
http://baigsorcl.blogspot.com/