Re: SQL -- getting values
From: padderz <member_at_dbforums.com>
Date: 8 Nov 2001 05:11:00 -0500
Message-ID: <3bea5a34$3_at_usenetgateway.com>
Date: 8 Nov 2001 05:11:00 -0500
Message-ID: <3bea5a34$3_at_usenetgateway.com>
Well the idea is a sound one, but you would use a function rather than a procedure, since only functions can be called directly from SQL. A skeleton example follows...
CREATE OR REPLACE FUNCTION current_semester RETURN enrollment.semester%TYPE IS v_rtn enrollment.semester%TYPE; BEGIN /* Derive semester here */ v_rtn := '013'; RETURN v_rtn; END; /
SELECT * FROM enrollment WHERE semester = current_semester; /
-- Padderz SYSOP, RevealNet PL/SQL Pipeline Senior Oracle Developer, Cellular Operations UK Padderz SYSOP, RevealNet PL/SQL Pipeline Senior Oracle Developer, Cellular Operations UK Posted via dBforums http://dbforums.comReceived on Thu Nov 08 2001 - 11:11:00 CET