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 Practices By Steven Feuerstein: (more…)
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 support multi-byte in addition to single-byte characters, like Chinese versus English for example.
As an Oracle database developer I have been using Quest Software Inc.’s SQL Navigator for years. We are currently involved in the implementation of Oracle E-Business Suite in our new plant in China. So, now we have the Chinese characters to worry about. It turns out that SQL Navigator does not support multi-byte characters and UTF8 encoding (which is needed to display Chinese characters), however, Oracle’s SQL developer does
Here is how SQL Navigator displays a query result that returns Chinese characters: (more…)
Filed in Oracle, Tips with 23 Comments | Tags: sql-developer, sql-navigator, toad, tool, utf8As 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: (more…)
Filed in Oracle, Technology with 3 Comments | Tags: plsql-developer, sql, sql-developer, sql-navigator, sqlplus, toad, toolSome 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: (more…)
Filed in Oracle, Technology with 13 Comments | Tags: sql-developer, sql-navigator, sqlplus, toad, toolEven 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 mode. I like the command-line mode because it is more flexible and can be used on any platform.
By default, when you start SQLPlus, the prompt changes to SQL>: (more…)