How to delete a user in Oracle 10 including all it's tablespace and datafiles

DROP USER---->
DROP USER USER_NAME CASCADE;
DROP TABLESPACE---->
DROP TABLESPACE TABLESPACE_NAME INCLUDING CONTENTS AND DATAFILES;

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%'