1、NVL2(AGE_MON,TO_CHAR(AGE_MON, 'FM0000'),'0000')
格式转换为4位字符串
2、
2013.05.30
ORACLE job
--查看JOB情况
select * from dba_jobs;
select * from dba_jobs_running;
--创建Job
http://www.cnblogs.com/conqueror/archive/2010/10/10/1847085.html
--ORACLE日期操作
http://www.iteye.com/topic/150762
h2:
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Database may be already in use: Locked by another process. Possible solutions: close all other connection(s); use the server mode [90020-73]
--查询表的列信息 SQLSERVER
select column_name, data_type, ordinal_position,*
from information_schema.columns
where table_schema = 'dbo'
and table_name = 'MED_CATALOG'
order by ordinal_position;