oracle存储过程中带空值的输入怎么写?COALESCE()函数用错了吗?(starttimeindate,endtimeindate,nameinnvarchar2,tnameinnvarchar2,cusersoutsysrefcursor)asbegin

Question

oracle存储过程中带空值的输入怎么写?COALESCE()函数用错了吗?
(start_time in date,end_time in date,name in nvarchar2,tname in nvarchar2,cusers out sys_refcursor)
as

begin

open cusers for select * from C_USERS where logintime >= COALESCE(start_time,logintime)
and logintime

Answer 1

空值 ,你直接用NVL不就行了.
open cusers for select * from C_USERS where logintime >= NVL(start_time,logintime)
and logintime