Tuesday, August 4, 2009

Masalah Precision Dalam ETL untuk Oracle OLE

1) Cast column to NUMBER(precision, scale) in Oracle select (eg. select CAST(columnName as NUMBER(10, 3)) as columName from ..

2) Cast to string in Oracle select (eg. select TO_CHAR(columnName) as columName from ..

No comments:

Post a Comment