公告

随笔分类 - Database Oracle

Sqoop export hive to oracle number format issue resolution

摘要：Problem:java.lang.NumberFormatException at java.math.BigDecimal.<init>(BigDecimal.java:459) at java.math.BigDecimal.<init>(BigDecimal.java:728) at CDR_D_DETAIL_LUC.__loadFromFields(CDR_D_DETAIL_LUC.java:9803) at CDR_D_DETAIL_LUC.parse(CDR_D_DETAIL_LUC.java:9630) at... 阅读全文

posted @ 2012-09-04 10:23 littlesuccess 阅读(1979) 评论(0) 推荐(0)

unique index可以有多个NULL值吗？

摘要：1.创建测试表和测试索性代码：CREATE TABLE "GSC"."UNIQUE_TEST"( "COL" VARCHAR2(20 BYTE));CREATE UNIQUE INDEX "GSC"."IDX_COL" ON "GSC"."UNIQUE_TEST" ("COL") 2.插入2条NULL数据INSERT INTO unique_test VALUES(NULL);SELECT * FROM unique_test;--显示阅读全文

posted @ 2011-10-17 08:19 littlesuccess 阅读(1079) 评论(0) 推荐(0)