(Seetaram Mehra) This tip lets you read the alert log entries from a SQL query (using SQL*Plus, TOAD, SQL Developer Worksheet, and so on). In this example, the query provides results for database startup_time/shutdown_time along with total number of days up.

(Dratz) Ok, I’m going to teach you how to write a sql statement and then I can get into all of those nice architectural pieces we’ve discussed. I know this is very, very basic, but I don’t want to skip over anything.

(Stephen Swoyer) It’s been a long time coming, but Oracle Corp.’s next-gen Warehouse Builder (OWB) is finally here. It’s actually been here for awhile now, according to Oracle officials, who note that OWB Release 2 has been available—to select customers, anyway—since early May.

(Vishwamithran S.) Large numbers of deletes or updates occurring within a table sometime leave relevant indexes larger than their table sizes. The following script is designed to identify these indexes and help to schedule a rebuild of them, after choosing appropriate storage parameters.

(Bob Watkins) Oracle 10g Release 1 added support for POSIX regular expressions for matching patterns in text strings. Release 2 extended the initial list of pattern metacharacters, with additional ones found in Perl. If you’re developing scripts against Oracle 10gR2, check out these nifty shortcuts

(Dratz) This part of the series shows what the Oracle SQL engine does in a nutshell.

Subversion is a powerful, open source version control system designed as a replacement for the popular Concurrent Versions System (CVS). It offers many enhancements to CVS, such as versioned directories and metadata, and is architected for simpler, more flexible network access. Oracle offers an ex

(Lewis R Cunningham) Oracle 10g provides three types of date related datatypes: date, timestamps and intervals. Today I will be talking about all three of these.

(Sue Harper) More in the Sneak Peak series…I’ll try to alternate with current and next release blog entries, so that you are not frustrated by future features. As the last entry was on running files in SQL Developer today, it means this entry is a piece about what’s coming down the line. (It’s mos

(Dratz) What is SQL, how is it pronounced, and where did it come from?