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
SQL*Plus is a handy command-line tool. If you’re using it as your main tool for running SQL, I would suggest using an IDE. I explain a few reasons why in this article. Ben BrummBen has over 10 years experience working in the software industry, and he enjoys teaching Oracle and database skills to other software… Read More Why You Should Use an IDE Instead of SQLPlus
B-tree and bitmap are two types of index in Oracle. What is b-tree and bitmap index? Learn here the difference between B-tree and bitmap index.… Read More What Is The Difference Between B-tree And Bitmap Index?
In this article you can learn about what is data dictionary, difference between ALL, USER and DBA views and list of frequently used data dictionary views… Read More Important Data Dictionary Tables A Programmer Must Know