Herşey ilk adımlarla başlar...

Thursday, January 27, 2011

Step By Step PL/SQL Tutorial ( Second Step : Passing Parameter )

1/27/2011 Posted by Nurettin Onur YAKIT , , , , , , No comments
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 NUMBER
IS
   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
 

0 comments: