-- select all table names starting with 'D_' select table_name from dba_tables where table_name like 'D\_%' escape '\' order by 1;