Learn about popular databases MySQL and Oracle and get the quality tips with collection of interview question and answers about database.
When you login into Oracle Database and it throws following error message: ORA-01033: ORACLE initialization …
Fixed – ORA-01033: ORACLE initialization or shutdown in progress Read More »
When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol …
When you start your database and it throws following error: ORA-01078: failure in processing system …
Fixed – ORA-00844: Parameter not taking MEMORY_TARGET into account Read More »
It’s a prime responsibility of Oracle DBA to keep database up 24×7 but there may …
How to Enable/Disable Archive Log Mode in Oracle 10g/11g Read More »
What is an Index? Index is created on existing tables to retrieve data more quickly. …
This article will provide you a summary of the NULL functions available for handling null …
NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle Read More »
This article gives you an overview of the RANK, DENSE_RANK, FIRST and LAST analytic functions. …
Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions Read More »
LAG and LEAD functions can be used in Oracle PL/SQL and apply on Oracle 12c, …
There are many ways to run SQL query using Unix shell script. Here we have …
Unix Shell Script to Execute SQL Query in Oracle Read More »