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 [...]

Drop database from mysql
The drop database command is used when you no longer need one of the SQL databases on your server. It will remove it permanently.
Query Syntax:
drop database databasename; //mysql
Examples: If the database to be dropped is called “customer_profile”, run the following query to delete the entire database. This will remove the database ‘customer_profile’ [...]

MySQL abbreviated as ” My Structured Query Language”
“. The program runs as a server providing multi-user access to a number of databases.
Web applications uses MySQL acts as the database component of the LAMP software stack. MySQL is used for data storage and logging of user data used by various high traffic websites includes YouTube, [...]

LDAP – Lightweight Directory Access Protocol
Lightweight Directory Access Protocol (LDAP) is an Internet protocol that email and other programs use to look up information from a server. LDAP shows a set of objects with attributes organized in a logical and hierarchical manner. In early stage LDAP is known as Lightweight Directory Browsing Protocol. It was [...]

High Performance MySQL
Optimization, Backups, Replication, Load Balancing & More

In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And [...]