|
SQL> set serveroutput on
SQL> set echo on
SQL>
SQL> CREATE OR REPLACE FUNCTION ss_thresh
2 RETURN NUMBER AS
3 x NUMBER(9,2);
4 BEGIN
5 x := 65400;
6 RETURN x;
7 END ss_thresh;
8 /
Function created.
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('ss_thresh ' || ss_thresh());
3 END;
4 /
ss_thresh 65400
PL/SQL procedure successfully completed.
SQL>
SQL>
|