How to drop database (schema) in Oracle

//List all schema:

SELECT username FROM all_users ORDER BY username; 

//Drop table test_db

drop user test_db cascade;