How to Multiplex Redo Log Files in Oracle
As a DBA, it’s your responsibility to multiplex redo log files just like multiplexing control …
Database
Learn about popular databases MySQL and Oracle and get the quality tips with collection of interview question and answers about database.
How to Multiplex Control Files in Oracle
As a DBA, you know that control files play a very important role in oracle …
How to Escape Special Characters in Oracle SQL queries
Whether you are working as PL/SQL developer or ETL developer or Data Warehousing Developer or …
How to Escape Special Characters in Oracle SQL queries Read More »
Transpose Rows to Columns and Columns to Rows in Oracle
This is the most popular question asked in an interview as well as over the …
Transpose Rows to Columns and Columns to Rows in Oracle Read More »
Oracle 11g Security Features: ORA-28001: The Password Has Expired
My friend called me today and told about Ora-28001: The password has expired. He told …
Oracle 11g Security Features: ORA-28001: The Password Has Expired Read More »
Difference Between DDL, DML and DCL Commands
This is the most important question asked in an interview. How to differentiate DDL, DML …
How to Delete Duplicate Rows from a Table
How to remove duplicate records from a Table? If you want to remove duplicate rows …
What is the Difference between Truncate and Delete in Oracle
First create a Table using following command on SQL> prompt. CREATE TABLE SAMPLE (ID NUMBER, …
What is the Difference between Truncate and Delete in Oracle Read More »
Oracle DBA Tips
You will find here Oracle DBA tips and techniques which will help you to resolve your issues. If you want to learn about these tips then follow the links.