Drop Data Base from oracle
DROP USER databasename cascade; //Oracle
It is possible to drop a database in Oracle with the new SQL statement drop database. The command gets rid of datafiles online redo log files, controlfiles and spfile.
Example to use the command
shutdown abort;
startup mount exclusive restrict;
drop database;
exit
Requirements
database must be closed,
exclusively mounted,
restricted

Get All Tables in a Oracle and MySql Schema
Oracle
In Oracle you can use the following query
select object_name from user_objects where object_type = ‘TABLE’;
MYSQL
In MySql you can use the follwing query
show tables;
Get All Schema in Oracle and MySql
ORACLE
We can get all oracle schemas using the following query
SELECT username FROM all_users;
or
SELECT * all_users;
MYSQL
We can get all mysql [...]