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

Toad Extension for Eclipse

Toad Extension for Eclipse gives you the power to perform essential Oracle database development tasks directly within the Eclipse IDE. This free Eclipse plug-in makes it seamless to work with Oracle databases and eliminates the need for multiple tools.

Read about its features and download from quest.com/toad-extension-for-eclipse/.

Comments Off | Filed in Oracle | Tags: ,


Now We Know What TOAD Means

Tab Overload And Deluge :)

toad.gif

source

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

6 Comments | Filed in Oracle | 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.

Comments Off | Filed in Oracle, Tips | 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: Continue reading…

23 Comments | Filed in Oracle, Tips | 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: Continue reading…

3 Comments | Filed in Oracle, Technology | 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: Continue reading…

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