Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - PL/SQL Question. Please Help!!
Use dynamic sql. The DBMS_SQL package
George Gifford <georgegifford@~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 Tue Jun 15 1999 - 20:04:44 CDT