When you code, you write your programs either in all lower case, all upper case, or a combination of the two. Let’s take PL/SQL for example, almost all PL/SQL programming best practices and coding styles that I’ve come across recommend using upper and lower. The following is an excerpt from the book Oracle PL/SQL Best […]

In this global economy the need for software globalization is increasing. As a result of this globalization, localization is becoming an important part of software development. And as a result of this localization, software developers like myself will have to work with multiple languages. So, it is becoming more crucial to have development tools that […]

As a follow-up to my previous post about the different SQL development tools, here is the result of the quick poll I had on this site.

I asked the question: What SQL development tool do you use most? There were a total of 150 answers, broken down like this:

Some Oracle professionals swear by SQL Plus, others just don’t even use it. There are a lot of tools out there for interacting with the Oracle database (and other databases as well) that serve as an alternative for SQL Plus; to name a few:

Even though I use Sql Navigator at work, I also often use SQLPlus. Almost everyone who has access to an Oracle database, has access to SQL*Plus. On the other hand, not everyone has SQL Navigator or similar third party tools installed on his/her machine.

SQLPlus can be started in GUI mode (Windows only) or in command-line […]