Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please check this syntax
Josh White wrote:
> OK. There will always be exactly one row although the BGTNO may be
> null.
>
>
>>> IF v_bgtNo IS NULL THEN >> >>No going to ever happen. Try SQL in SQL*Plus before ever putting >>it into NDS.
NULL. But why not just do this:
SELECT CT.COMPCODE
INTO v_compType
FROM COMPTYPE CT
WHERE CT.COMPTYPE = :newRow.COMPTYPE;
IF v_compType IS NULL THEN
do something;
END IF;
Why make it so complex?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Mon Apr 04 2005 - 10:23:16 CDT