create and call an oracle function

davetrane (David Davis) — Wed, 06 Jun 2007 21:22:16 GMT



create or replace function "ORACLE_FOO"

(foo_arg1 in NUMBER)

return NUMBER

is

rt NUMBER := 0;

begin

  IF foo_arg1 > 1 THEN

    SELECT 1 INTO rt;

  ELSE

    SELECT 2 INTO rt;

  END IF;

  RETURN (rt);

end;



SELECT ORACLE_FOO(1) FROM dual;

DZone Snippets: plsql code

create and call an oracle function