CREATE [OR REPLACE] FUNCTION function_name (arg, arg, arg) RETURN return_type IS --- END;
SELECT function_name (arg, arg, arg...) FROM dual; SELECT columns FROM xpt where xpt.id = function_name (arg, arg, arg...); IF function_name (arg, arg, arg...) = ... THEN ...