| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ps/sql and defaults
Lisa and list,
Thanks for your feedback on the selecting or not selecting values from the =
tables.
The problem was fixed by using the nvl(fld1,0) in the select clause in the =
package. I nvl'd all of the numeric fields and the package worked as =
required. Is there was no matching id in the second table to union and =
join with the id in the first table, the field returned the value of 0 =
rather than a null.
Thanks,
ROR =AA=BF=AA
Received on Fri Nov 03 2000 - 06:43:39 CST
 |
 |