How to Multiplex Control Files in Oracle
As a DBA, you know that control files play a very important role in oracle …
As a DBA, you know that control files play a very important role in oracle …
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 »
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 »
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 »
This is the most important question asked in an interview. How to differentiate DDL, DML …
How to remove duplicate records from a Table? If you want to remove duplicate rows …
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 »
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.
PL/SQL (Procedural Language/Structured Query Language) stands for Procedural Language extension of SQL. This Oracle PL/SQL …