C# 与 Oracle 中 BINARY_DOUBLE数据类型查询
时间:2016-02-17 17:07:21
收藏:0
阅读:335
Oracle 10g新增 BINARY_DOUBLE 数据类型,而.NET暂不支持这个类型,查询时需要转换为 NUMBER。
eg:
"SELECT RAWTOHEX(OID) AS OID,RAWTOHEX(FLAVOROID) AS FLAVOROID,BISMATRIX," +
"CAST(SERVERTOCLIENT0 AS NUMBER(38,15)) AS SERVERTOCLIENT0," +
"CAST(SERVERTOCLIENT1 AS NUMBER(38,15)) AS SERVERTOCLIENT1 from table"
原文:http://www.cnblogs.com/nidongde/p/5195787.html
评论(0)