Query to Find Column From All Tables of Database in Oracle

Oracle
---------

select table_name from all_tab_columns where column_name='IPADDRESS';

---------------------
SQL Server 2008
---------------------

SELECT ROUTINE_NAME, ROUTINE_DEFINITION, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%ABCD%'