!懒人,给你个例子: CREATE OR REPLACE FUNCTION FU_TEST(SJ VARCHAR2) RETURN NUMBER IS val DATE; BEGIN val := TO_DATE(SJ, 'yyyy-mm-dd'); RETURN 1; EXCEPTION WHEN OTHERS THEN RETURN 0; END;
/--自建函数SQL> create or replace function f_test(v_intb in number) return number is 2 begin 3 return (v_intb * 0.15); 4 end; 5 /Function created/--函数使用SQL> select f_test(100) from dual;F_TEST(100) ----------- 15SQL>
/--自建函数SQL> create or replace function f_test(v_intb in number) return number is 2 begin 3 return (v_intb * 0.15); 4 end; 5 /Function created/--函数使用SQL> select f_test(100) from dual;F_TEST(100) ----------- 15SQL>
CREATE OR REPLACE FUNCTION FU_TEST(SJ VARCHAR2)
RETURN NUMBER
IS
val DATE;
BEGIN
val := TO_DATE(SJ, 'yyyy-mm-dd');
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RETURN 0;
END;
2 begin
3 return (v_intb * 0.15);
4 end;
5 /Function created/--函数使用SQL> select f_test(100) from dual;F_TEST(100)
-----------
15SQL>
/--自建函数SQL> create or replace function f_test(v_intb in number) return number is
2 begin
3 return (v_intb * 0.15);
4 end;
5 /Function created/--函数使用SQL> select f_test(100) from dual;F_TEST(100)
-----------
15SQL>