Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
pl/sql update nulls
Name: fleetmack Date: May 28, 2008 at 11:20:53 Pacific OS: 9.2.0.6 CPU/Ram: fast/a lot Product: lenovo
Comment:
I am looking for a SQL (or PL/SQL) script that will dynamically update every column of an Oracle 9i table by placing a word in place of all null values WITHOUT listing each individual column, such that if the number or names of the columns in the table change, the script will still work.
basically I need a statement that functions as the NVL statement but works for every column in a table, without listing each (or any) column names. Is this possible?
Summary: "I get the impression that temp2 is a variable, and assuming temp2="hello", you would go to the page UU.PP?psU='||hello||' " This syntax would go to UU.PP?psU=hello if it were to work correctly. I agr...
Summary: Does anyone know of a program what will automaticly format your PL/SQL statements simular in fashion to the way Microsoft Visual C++ does to C/C++ source code? Writing PL/SQL code in Notepad is a bit...
