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
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
Operators in PL/SQL plays an important role to identify selective data from large chunks of transactions. Let us learn more about it here.… Read More Operators in PL/SQL
Looping is the basic fundamental thing of any programming language. It plays an important role in the iteration of records. Let us learn more about it here.… Read More PL/SQL Loop With Example
This is Part 3 of the series of 4 Useful SQL Tips and Tricks of SQL and PL/SQL that is useful for beginners as well as seasoned programmers. Happy Reading!… Read More 25 Useful SQL Tips And Tricks That You Should Know – Part 3