Oracle November 1, 2010 0

Types of SQL Statements

A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to…

Oracle March 5, 2010 2

Drop multiple tables from users schemas

Scenario: To drop, truncate multiple or all tables from user’s schema. Let’s suppose we’ve got the following tables in user’s schema…

Oracle March 18, 2009 0

Redo Online Logs: add clear move delete

After default database 10g installation usually we’ve got 2-3 redo log files in 2-3 groups: SQL>select GROUP#, member from v$logfile; GROUP#…