学点PL/SQL

The major difference between a procedure and a function is, a function must always return a value, but a procedure may or may not return a value.

 

CREATE [OR REPLACE] FUNCTION function_name [parameters] 

RETURN return_datatype;  

IS  

Declaration_section  

BEGIN  

Execution_section 

Return return_variable;  

EXCEPTION  

exception section  

Return return_variable;  

END;