String To date:todate('date_str','format_str')
select id from t where date1>to_date('2006-12-12','YYYY-MM-DD')
Date To String:tochar(date,'format-str')
select to_char(sysdate,'yyyy-mm-dd') mydate_str from dual
结果变换,空变换
select DECODE('1','1','录入中','2','已录入','未录入')STATUSNAME,NVL('1',0) STATUS from dual
/
1. sql> desc outp_bill_items
2. sql> grant select on outp_bill_items to your_user;