select ORDER_ID,
ORDER_STATUS,
ORDER_TYPE,
ACCT_TIME,
Acct_Flag,
ORDER_PRICE
from deal_order
where 1 = 1
and to_char(ORDER_PAY_TIME, 'yyyymmdd') = '20130124'
and nvl(acct_flag,' ')!=' ' ;
ORDER_STATUS,
ORDER_TYPE,
ACCT_TIME,
Acct_Flag,
ORDER_PRICE
from deal_order
where 1 = 1
and to_char(ORDER_PAY_TIME, 'yyyymmdd') = '20130124'
and nvl(acct_flag,' ')!=' ' ;
小结:nvl使用
!使用
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-753481/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-753481/