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
This can be a totally off post from technology perspective. But sometimes a bit of diversion is necessary to gear ourselves up. Perhaps, a motivational video could be of great help here for all of us, I guess. Whenever we find ourselves in hard situation, we think it is insurmountable. Most of the times people… Read More Watch Best Motivational Video of Larry Ellison – Founder of Oracle Corporation
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
Oracle Forms is an integral part of Oracle Applications. Let us see here how to Develop Oracle Forms from scratch for Oracle E-Business Suite… Read More How to Develop Oracle Form for Oracle E-Business Suite?
Oracle Developers often work with EMP and DEPT tables along with BONUS and SALGRADE. In this post you will find table structures and values of four most prominently used sample tables in Oracle… Read More EMP and DEPT tables in Oracle