Thursday, November 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 [...]

Secure Linux Web Hosting