oracel: select * from all_source where upper(text) like '% table name %' sql: select a.name from sysobjects a ,syscomments b where a.id=b.id and b.text like '% table name %'