Post a Comment On: Step by Step Tutorials

How to pass parameter to PL/SQL Function ? 


Now we now how to create function an already created one.  It is the time for creating a little bit useful function ; a function with parameter :)

CREATE OR REPLACE FUNCTION funct_user_source_count_name (param_name IN varchar2)RETURN NUMBERIS   dummy NUMBER;BEGIN   SELECT  count(name) INTO dummy FROM user_source WHERE name = param_name;   RETURN dummy;END;/
You are able to call from SQL like this ;

SELECT funct_user_source_count_name('MIGRATION_REPORT') from dual