摘要： Sql Server数据类型 Oracle数据类型Char,Varchar Varchar2Smalllint,int,bigint,bit intfloat/dec/decimal/numericNUMBERText,image,binary blobDate,time,datetime Datesqlserveroracle说明SELECT NAME FROM sysobjectsselect TABLE_NAME from user_tables查看表名是否存在Year（）to_char(sysdate,'yyyy')取年Month（）to_char(sysdate,&# 阅读全文