SQL语句处理备注

jsnjzlw

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.iyunv.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;