1 PACKAGE QLTCOMPB AUTHID CURRENT_USER AS
2 /* $Header: qltcompb.pls 115.3 2002/11/27 19:22:58 jezheng ship $ */
3 -- Compare Functions for the server
4 -- 2/8/95
5 -- Kevin Wiggen
6
7
8 FUNCTION compare(value1 IN VARCHAR2,
9 operator IN NUMBER,
10 value2 IN VARCHAR2,
11 value3 IN VARCHAR2)
12 RETURN BOOLEAN;
13
14 FUNCTION compare(value1 IN NUMBER,
15 operator IN NUMBER,
16 value2 IN NUMBER,
17 value3 IN NUMBER)
18 RETURN BOOLEAN;
19
20 FUNCTION compare(value1 IN DATE,
21 operator IN NUMBER,
22 value2 IN DATE,
23 value3 IN DATE)
24 RETURN BOOLEAN;
25
26 -- Bug2336153. Added compare_seq function to support Sequence Datatype
27
28 FUNCTION compare_seq(value1 IN VARCHAR2,
29 operator IN NUMBER,
30 value2 IN VARCHAR2,
31 value3 IN VARCHAR2)
32 RETURN BOOLEAN;
33
34 FUNCTION compare(value1 IN VARCHAR2,
35 operator IN NUMBER,
36 value2 IN VARCHAR2,
37 value3 IN VARCHAR2,
38 datatype NUMBER)
39 RETURN BOOLEAN;
40
41 END QLTCOMPB;
42