Re: SQL - PL/SQL Question. Please Help!!
From: Al Ruiz <arruiz_at_flash.net>
Date: Wed, 16 Jun 1999 01:04:44 GMT
Message-ID: <MKC93.581$IY1.1584_at_news.flash.net>
Date: Wed, 16 Jun 1999 01:04:44 GMT
Message-ID: <MKC93.581$IY1.1584_at_news.flash.net>
Use dynamic sql. The DBMS_SQL package
George Gifford <georgegifford_at_~usa~.net <--- ANIT-SPAM (Remove ~)> wrote in
message news:LgB93.38$5E4.10347_at_news2.randori.com...
> Does anyone have any suggestions or pl/sql code that will accept a
tablename
> and then update/replace ALL Null Numeric fields with a 0, and all Null
> VarChar2 Fields with a space (' ')??
>
> Or a PL/SQL Block that will run through each record in a table and update
> specific fields with a default value???
>
> Any help would be greatly appreciated!!!
>
> George - SSI
>
>
Received on Wed Jun 16 1999 - 03:04:44 CEST