17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT column1, column2
FROM table t
WHERE t.TIME BETWEEN NVL(TO_DATE (parameter1, 'yyyy-mm-dd hh24:mi:ss'),t.TIME)
AND NVL(TO_DATE (parameter2, 'yyyy-mm-dd hh24:mi:ss'),t.TIME)
SELECT column1, column2
FROM table t
WHERE t.TIME BETWEEN NVL (TO_DATE (parameter1, 'yyyy-mm-dd hh24:mi:ss'),
t.TIME
)
AND NVL (TO_DATE (parameter2, 'yyyy-mm-dd hh24:mi:ss'),
t.TIME
)
select * from table where A like nvl('B','%');