From oracle-l-bounce@freelists.org Fri Jun 4 12:41:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i54HfKi00972 for ; Fri, 4 Jun 2004 12:41:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i54HfA600914 for ; Fri, 4 Jun 2004 12:41:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C5D7F72C459; Fri, 4 Jun 2004 12:27:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23855-77; Fri, 4 Jun 2004 12:27:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16B7772C60E; Fri, 4 Jun 2004 12:27:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 04 Jun 2004 12:26:12 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 853E672C543 for ; Fri, 4 Jun 2004 12:26:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23855-55 for ; Fri, 4 Jun 2004 12:26:12 -0500 (EST) Received: from fed1rmmtao03.cox.net (fed1rmmtao03.cox.net [68.230.241.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCD6B72C4DA for ; Fri, 4 Jun 2004 12:26:11 -0500 (EST) Received: from smtp.west.cox.net ([172.18.180.57]) by fed1rmmtao03.cox.net (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with SMTP id <20040604174446.TRXU20703.fed1rmmtao03.cox.net@smtp.west.cox.net> for ; Fri, 4 Jun 2004 13:44:46 -0400 From: To: oracle-l@freelists.org Subject: Re: Food for thought Date: Fri, 4 Jun 2004 13:44:44 -0400 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=____1086371084833_PiDCxGfdhw" Message-Id: <20040604174446.TRXU20703.fed1rmmtao03.cox.net@smtp.west.cox.net> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2020 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: solbeach@cox.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=____1086371084833_PiDCxGfdhw Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Also new in DB2 "STINGER" is "you can now invoke procedures from triggers". ------=____1086371084833_PiDCxGfdhw Content-Type: text/html; name="reply" Content-Disposition: inline; filename="reply"


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
>
> ------------------------------------------------------------
>


------=____1086371084833_PiDCxGfdhw-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------