Thursday, February 23rd, 2017

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

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

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

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

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

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

Secure Linux Web Hosting