Food for thought

From: <Jared.Still_at_radisys.com>
Date: Fri, 4 Jun 2004 10:34:15 -0700
Message-ID: <OFE2EF042E.D3EF4561-ON88256EA9.006036E7-88256EA9.006082D6@radisys.com>

Some items from Database Journal that may stimulate some discussion.

We sometimes take PL/SQL for granted. We sometimes forget how well off we are with this language.

> *********************************************************************
>
> 1. What's New for SQL PL in the IBM DB2 Universal Database "Stinger"
Release
> June 1, 2004
> Part two of our Stinger preview series examines the new architecture for

> native SQL PL stored procedures that no longer require a C compiler.
>
> http://nl.internet.com/ct.html?rtr=on&s=1,xic,1,5pzq,fjl0,it1j,m22r
>

This author flunked relational algebra.

>
> 3. Storing Multiple Statuses Using an Integer Column
> May 31, 2004
> How many applications do you have that capture a status field for one
> reason or another? Do these status fields support only a single status
> value at a time? Learn how to use an integer field to support having
> multiple statuses assigned to records at the same time.
>
> http://nl.internet.com/ct.html?rtr=on&s=1,xic,1,lo43,iowu,it1j,m22r
>

An interesting feature of DB2. Would be useful in DW and DM.

> ------------------------------------------------------------
>
> 4. An IBM DB2 Universal Database "Stinger" Feature Preview: Dynamic
> Generated Columns
> May 28, 2004
> This article is the first in a series that introduces some of the new
> features in DB2 UDB 'Stinger.' Included are examples that you can use
with
> the open beta today.
>
> http://nl.internet.com/ct.html?rtr=on&s=1,xic,1,idne,j4nc,it1j,m22r
>

Some possibly useful examples for DBMS_RANDOM. Though I think it is much easier to generate test data from the dictionary. Faster too.

>
> 9. Generating random numbers and strings in Oracle
> May 25, 2004
> Generating random numbers or strings is oft-times a necessity. Oracle
> provides a random number generator that is faster than writing your won
> random generation logic in PL/SQL, and can generate both character and
> alphanumeric strings. Perhaps it is time to learn more about the
> DBMS_RANDOM package.
>
> http://nl.internet.com/ct.html?rtr=on&s=1,xic,1,ir6i,jhm,it1j,m22r
>
> ------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 04 2004 - 12:31:30 CDT