A Data Manipulation Language (DML) is a family of computer languages used by computer programs and/or database users to…
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…
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#…