Comparing NULLs in Oracle SQL
by Nulls are special in Oracle SQL – we can’t directly compare them since they won’t equal anything including themselves.
Use Oracles NVL() function to compare fields that may contain Null values
Category: SQL
PSQuery Date Math
PSQuery is a great tool for PeopleSoft ad hoc reporting. But it does have a challenge when it comes to working with Dates.
Use MetaSQL to manipulate dates in PSQuery
Creating Materialized Views in PeopleTools
Use Materialized Views to improve poor performance of complex SQL Views