03 2012 档案

Oracle data types and corresponding DataStage data types
摘要：Oracle data types and corresponding DataStage data typesOracle data typeDataStage data typeCHAR(nBYTE)SQL type: CHARLength:nScale: unsetExtended: unsetCHAR(nCHAR ) single-byteSQL type: CHARLength:nScale: unsetExtended: unsetCHAR(nCHAR) multibyteSQL type: NCHARLength:nScale: unsetExtended: unsetCHAR 阅读全文

posted @ 2012-03-25 13:16 猎-户-座 阅读(759) 评论(0) 推荐(0)

SQL Server 和Oracle 数据类型对应
摘要：SqlServer 2k转换为Oracle 10g列名SqlServer数据类型SqlServer长度Oracle数据类型column1bigint8 NUMBER(19)column2binary50 RAW(50)column3bit1 NUMBER(2)column4char10 CHAR(10)column5datetime8 DATEcolumn6decimal9 NUMBER(18)column7float8 BINARY_DOUBLEcolumn8image16 BLOBcolumn9int4 NUMBER(10)column10m... 阅读全文

posted @ 2012-03-22 17:15 猎-户-座 阅读(8636) 评论(2) 推荐(2)

oracle 时间转换
摘要：己知 秒 sec 换算成00：00：00格式floor(sec/3600)||':'||floor((sec-floor(sec/3600)*3600)/60)||':'||((sec/60)-floor(sec/60))*60 阅读全文

posted @ 2012-03-08 12:26 猎-户-座 阅读(398) 评论(0) 推荐(0)

导航