To find nth highest salary is a question basically every Oracle developer might have encountered. Let us see here different ways to find nth highest salary in Oracle… Read More Different Ways To Find Nth Highest Salary In Oracle
Let us see here how to solve ORA-01789 – query block has incorrect number of result columns error in Oracle.… Read More SOLUTION: ORA-01789 Error in Oracle
Do nothing and win $50 amazon gift card from OracleMine.com. Go to OracleMine Facebook page, tag your friends, like OracleMine and subscribe to OracleMine.com… Read More Do NOTHING And Win $50 Amazon Gift Card
A single SQL query that solved my Sudoku in seconds. You don’t believe it right? Then come check it out. You will be amazed by power of SQL.… Read More This Single SQL Query Solved My Sudoku In Seconds
Let us learn two important standard functions SUBSTR and INSTR of SQL that you will use extensively while writing queries.… Read More SUBSTR and INSTR in Oracle
Do you know SQLCODE and SQLERRM functions are best way to handle exceptions in Oracle? Let us look in detail into it with syntax and examples… Read More SQLCODE and SQLERRM in Oracle
We often work with Raise_Application_Error. But how does it differs from RAISE? Let us learn difference between RAISE and RAISE_APPLICATION_ERROR here.… Read More Difference between RAISE and RAISE_APPLICATION_ERROR in Oracle
