Archives: oracle
-
Useful SQL*Plus headers:
Quick stuff that I seem to be repeating to quite a lot of people! (82 Words)
[August 21, 2009 08:52 PM]
-
Dino eats frog:
Confused? It is about Oracle. (158 Words)
[December 29, 2005 06:07 PM]
-
Oracle with Active Record:
Thanks to ActiveRecord, it is a breeze to program Oracle using Ruby. Here's a quick note about how to do this on MS Windows. (201 Words)
[July 19, 2005 01:50 PM]
-
When is he free?:
I thought this will be simple. I ended up with a pretty big SQL. Is there a simpler way? (3239 Words)
[April 30, 2004 08:41 AM]
-
Gentle dive into analytic functions:
A small example to illustrate using analytic functions to solve a (silly) query requirement. (1508 Words)
[April 29, 2004 03:26 PM]
-
Pivoting for dates - summary:
Collection of interesting questions readers asked about newbie SQL on Oracle. (1116 Words)
[April 19, 2004 04:42 PM]
-
On-line discussion on Larry Ellison:
With the author of the book "SOFTWAR: An Intimate Portrait of Larry Ellison and Oracle" (250 Words)
[February 26, 2004 09:10 AM]
-
Jython is great:
Long overdue note on the ease and elegance of Jython. (141 Words)
[February 24, 2004 12:13 PM]
-
Quick Links:
Links I didn't want to forget later -- well, it is a Sunday morning after all. (250 Words)
[January 18, 2004 09:43 AM]
-
Oracle 9i skills and DB2:
Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8 (73 Words)
[January 10, 2004 06:37 PM]
-
Preventing duplicates in VARRAY columns:
Today, I got an interesting question from a visitor to my site. (795 Words)
[January 04, 2004 02:04 PM]
-
Pivoting on ALL_OBJECTS:
Tom Kyte takes ROWNUM to make some very slick queries. (363 Words)
[December 27, 2003 09:44 PM]
-
PCTUSELESS:
I had an epiphany today. Analogous to Oracle's storage parameters, here is how it looks. (311 Words)
[December 15, 2003 08:00 AM]
-
LEAD over rows:
Another useful Oracle SQL function that makes getting data out using queries much more easier. (309 Words)
[December 10, 2003 08:21 AM]
-
Respecting SQL:
SQL is getting unfashionable among Java crowd. It doesn't have to be - you get reliability, maturity and familiarity with your data, using SQL. (660 Words)
[October 13, 2003 04:14 PM]
-
Oracle 10g launch:
Went to the 10g launch in DC today. So thoroughly bored that I came back within an hour. (424 Words)
[October 07, 2003 07:16 PM]
-
JDeveloper 10g - Look and Feel:
How-to: Apply Kunststoff look-and-feel for JDeveloper 10g on Linux. (213 Words)
[October 05, 2003 05:53 PM]
-
JDeveloper 10g - lighter!:
An accident happened. Made things faster. Don't know if it is reproducible in other machines. (326 Words)
[September 30, 2003 06:02 PM]
-
JDeveloper for WS client development:
Newbie notes on how developing a Google consumer using JDeveloper. (795 Words)
[September 28, 2003 06:04 PM]
-
JDeveloper 10g on Linux:
It runs very well on Linux. (478 Words)
[September 22, 2003 10:54 AM]
-
Jython zxJDBC rocks!:
Jython with zxJDBC makes life so much easier for data maintenance scripts. (200 Words)
[September 15, 2003 06:05 PM]
-
This one is for bookmarks:
All it took was 4 lines in a cross-posting to 4 newsgroups. And wishlist for Oracle. (438 Words)
[September 14, 2003 06:19 PM]
-
Updates to feeds:
Feed on feeds get categorization and opml. (179 Words)
[September 14, 2003 11:17 AM]
-
Oracle with C#:
What has 3 seconds got to do with opening an Oracle connection from Microsoft's .Net provider for Oracle? (260 Words)
[September 08, 2003 07:41 AM]
-
Multi-level collections:
Latest in a series of articles about Oracle 9i's new features. (116 Words)
[February 12, 2003 05:50 AM]
-
PHP & Oracle performance:
A mail reply to a question I got on performance issues with Oracle and PHP (309 Words)
[February 12, 2003 05:45 AM]
-
Table Functions and Cursor Expressions:
Another one in the series of articles about Oracle 9i and PL/SQL. (173 Words)
[January 26, 2003 08:40 PM]
-
Stored procedures for security:
Using procedures to hide your data, based on logical rules. (481 Words)
[January 08, 2003 01:52 PM]
-
PL/SQL grows a bit more:
New features in Oracle 9i for PL/SQL (187 Words)
[January 08, 2003 01:47 PM]
-
New Datatypes, New Possibilities:
Third installment in a series of articles about what is new in Oracle 9i. (221 Words)
[December 10, 2002 05:42 AM]
-
Updating data in Oracle:
What is there to write about this? Perhaps there is! (605 Words)
[November 20, 2002 07:45 AM]
-
Oracle linkfest, November 2002:
Oracle-ish stuff that caught my attention today. (241 Words)
[November 19, 2002 06:38 AM]
-
Inheritance in Oracle 9i:
Good article if you want to know what more have been crammed into Oracle 9i, for OOP. (149 Words)
[October 30, 2002 09:41 AM]
-
Introduction to Oracle data dictionary:
Getting around Oracle (61 Words)
[October 29, 2002 05:55 AM]
-
Newbie SQL: Current week range:
Newbie queries to get date range. (494 Words)
[October 25, 2002 05:36 PM]
-
SQL Standards - The History:
Two opinion pieces from Oracle Technology Network. (85 Words)
[September 25, 2002 05:43 AM]
-
Spreadsheet Design!:
Why not to design your databases like a spreadsheet. (721 Words)
[September 12, 2002 09:48 AM]
-
Perl for Oracle:
Some nice modules and scripts for using Oracle from Perl. (219 Words)
[September 05, 2002 07:32 AM]
-
Oracle performance tuning site:
Ixora.com.au has good information on tuning Oracle on Unix. (14 Words)
[June 16, 2002 08:08 AM]
-
Oracle and open source tools:
Link fest of open source tools for Oracle. (40 Words)
[June 09, 2002 05:17 PM]
-
JDO and object base:
O'Reilly Net: Flawed JDO Points the Way to the "Objectbase". Has some good examples using Oracle's object-relational mapping features. "We... (165 Words)
[April 25, 2002 05:31 AM]
-
Personal Oracle, Designer, Developer and Win98:
Last week, I took a look back at what I've been doing for 2 years now. To my surprise, I... (100 Words)
[April 21, 2002 04:38 PM]
-
LOBs from Zope:
Peter has a nice how-to on using Oracle LOBs from within Zope. Coupled with Oracle's InterMedia search, this should make... (45 Words)
[March 25, 2002 02:53 PM]
-
Oracle 8.1.6 on Mandrake:
Installed Oracle 8i 8.1.6 on Mandrake 8.0 today to go back to learning Oracle. Mandrakeuser.org's documentation was a big help.... (20 Words)
[March 22, 2002 09:48 AM]
-
TOra: better than TOAD:
This morning, downloaded and tried out TOra, a tool to work with Oracle. It is similar in spirit to TOAD.... (36 Words)
[March 14, 2002 11:40 AM]
-
Tuning Oracle backed ASP application:
Last week, I worked on some one else's code to "clean up, speed up and make it work". This was... (711 Words)
[March 13, 2002 08:13 AM]