Oracle 学习手札

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;