msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Now We Know What TOAD Means

Tab Overload And Deluge :)

toad.gif

source

Pop quiz: How many tabs are there in a Toad?

Filed in Oracle with 6 Comments | Tags:


Oracle PL/SQL Best Practices and Common Mistakes Videos

Here is Steven Feuerstein, the renowned Oracle PL/SQL guru, presenting “PL/SQL Best Practices, making the most of the of Oracle PL/SQL”:

And here is another presentation by Steven titled “You Wrote What? an examination of common coding mistakes made by PL/SQL Developers and how you can avoid them”:

Note: These videos are provided by Quest Software.

You can download the presentations in the videos above, and more, from oracleplsqlprogramming.com/resources.html.

Filed in Oracle, Tips with Comments Off | Tags: ,


SQL Developer and UTF8

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: , , , ,


Your SQL Tool Part II

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: (more…)

Filed in Oracle, Technology with 3 Comments | Tags: , , , , , ,


Your SQL tool

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: (more…)

Filed in Oracle, Technology with 13 Comments | Tags: , , , ,