(Mark Brunelli) Oracle’s free SQL Developer could mean trouble for Quest Software Inc.’s widely used Toad for Oracle software. (R)

(Stephan Holl, Helena Mitasova, and Markus Neteler) Recent advances in geospatial technologies, including Global Positioning System (GPS), satellite imaging, 3-D laser scanning, and Geographic Information Systems (GIS), have dramatically shortened the time needed for georeferenced data acquisition a

(Jayant Kulkarni) This script can be run on Oracle8i, Oracle9i and Oracle 10g databases to get a report/graph on tablespace free information, somewhat similar to the report from Oracle Enterprise Manager. The report provides a look at all the tablespaces in a database with information like “number o

(China Martens) Oracle is set to make its visual SQL Developer tool generally available. Formerly known as Project Raptor, the free software will be Oracle’s first visual database development tool, according to company’s executives.

(Steven Swafford) Encryption and decryption is fairly common in many web applications today. If you are using an Oracle Database as your data store, then you can easily implement encryption and decryption at the database level using the DBMS Obfuscation Toolkit provided by Oracle.

(Jagadish Chatarji) In this series of articles, we shall concentrate on working with associative arrays in Oracle PL/SQL. Even though I start with simple examples in the first article of this series, I shall introduce you (in my upcoming articles) to the power of much more advanced techniques using

(James F. Koopmann) Everyone is looking for an edge. With PL/SQL that edge is compiling the PL/SQL code into native code. This article will show you how to setup and compile your PL/SQL procedures and packages.

(Luis Adalberto) Running this query will produce a list of database statements and objects that are using the most resources.

(Arup Nanda) Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manag

(paviagrawal) These rules are simple but easy to follow and will yield lots of benefits.