select mnu_code from lu_mnu_code where mnu_code = :mnu_code
DECLARE
l_exist CHAR (1);
l_code_change CHAR (1);
BEGIN
SELECT CASE
WHEN EXISTS (SELECT *
FROM lu_mnu_code
WHERE NVL (mnu_code, 'null') = :mnu_code
) THEN 'Y'
ELSE 'N'
END
INTO l_exist
FROM DUAL;
IF l_exist = 'Y' THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter