As you may already know, Google recently released Google Gears, an open source browser extension that lets developers create web applications that can run offline using JavaScript APIs.

Google Gears provides three key features:

A local server, to cache and serve application resources (HTML, JavaScript, images, etc.) without needing to contact a server. […]

In his latest post titled Less is More, More or Less, John Russell, the man behind tahiti.oracle.com, reveals a very interesting fact about the space needed to store PL/SQL variables of varchar2 datatype. He writes:

If you don’t know exactly how much space is needed for a PL/SQL variable, the most space-efficient thing you can do […]

I stumbled on the following SQL*Plus tips at a new Oracle blog called Tahiti Views:

@ (”at” sign) vs. @@ (double “at” sign): With @@, all the import commands are processed relative to the directory where the original file sits, not the directory where you run SQL*Plus.

Splitting Up Package Code: You can split a big PL/SQL […]

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:

I downloaded part of Tom Kyte’s newest book “Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions” from Tom’s blog and started reading with interest (Can’t wait until the book is available at Amazon). I got to page 25, “Setting Up Your Environment” and read through page 28 when I noticed the […]

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:

While reading the oracle-l mailing list, someone asked a question about (auto)commiting transactions in SQL Plus. Consider:

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 […]