Since the PeopleSoft table naming convention is to use as many underscores as possible, I’ve run into many snafus since the underscore is a special character in SQL. Clark (via Linda) showed us some ways around this.


select count(*)
from dba_tables
where table_name like '%\_UM' escape '\'
COUNT(*)
----------
113
1 row selected

This query, below, would pick up table names like PS_EXT_ACAD_SUM.

select count(*)
from dba_tables
where table_name like '%_UM'
COUNT(*)
----------
132
1 row selected