Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL - PL/SQL Question. Please Help!!

SQL - PL/SQL Question. Please Help!!

From: George Gifford <georgegifford_at_~usa~.net>
Date: Tue, 15 Jun 1999 16:28:11 -0700
Message-ID: <LgB93.38$5E4.10347@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 - 18:28:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US