Oracle 用户定义运算符的函数

CREATE OR REPLACE package fn_contains 
AS 
FUNCTION fn_contains_si( 
stringin VARCHAR2, valuein  VARCHAR2) RETURN NUMBER; 
 
FUNCTION fn_contains_no( 
stringin VARCHAR2, valuein  VARCHAR2) RETURN NUMBER; 
 
END fn_contains; 
/

CREATE OR REPLACE package body fn_contains 
AS 
FUNCTION fn_contains_SI( 
stringin VARCHAR2, valuein  VARCHAR2) RETURN NUMBER IS 
 
BEGIN 
  IF INSTR(stringin, valuein, 1, 1) = 0 THEN 
    RETURN 0; 
  END IF; 
 
  RETURN 1; 
END fn_contains_SI; 
FUNCTION fn_contains_NO( 
stringin VARCHAR2, valuein  VARCHAR2) RETURN NUMBER IS 
 
BEGIN 
  IF INSTR(stringin, valuein, 1, 1) = 0 THEN 
    RETURN 1; 
  END IF; 
 
  RETURN 0; 
END fn_contains_NO; 
 
END fn_contains; 
/

CREATE OR REPLACE OPERATOR cns 
BINDING(VARCHAR2, VARCHAR2) RETURN NUMBER USING fn_contains.fn_contains_no ;

select * from user_opbindings;

OWNER  OPERATOR_NAME  BINDING#  FUNCTION_NAME                   RETURN_SCHEMA  RETURN_TYPE  IMPLEMENTATION_TYPE_SCHEMA  IMPLEMENTATION_TYPE  PROPERTY  
CHRIS  CNS            1         "FN_CONTAINS"."FN_CONTAINS_NO"                 NUMBER       CHRIS                                                      

select * from user_oparguments;

OWNER  OPERATOR_NAME  BINDING#  POSITION  ARGUMENT_TYPE  
CHRIS  CNS            1         2         VARCHAR2       
CHRIS  CNS            1         1         VARCHAR2