Checklist for Database Related Programing

Don't 
1)Try not to  update columns that are part of any index. It causes your program to be very slow.



Do's
1)Try to keep functionally same column with the same column name across tables
2)Handle NULL values with NVL's.
3)Use systimestamp instead of current_timestamp