Re: Daylight savings patch.....do you need it?

Try this in 10g R2
select owner,table_name,COLUMN_NAME,DATA_TYPE from dba_tab_columns where owner in ('SYS','SYSTEM') and DATA_TYPE like '%TIMESTAMP%';

As per Oracle Metalink docs, they strongly recommend applying the DST patch on all 9i and 10g DB.

HTH. Received on Tue Feb 06 2007 - 16:32:00 CST