Showing posts with label Precision. Show all posts
Showing posts with label Precision. Show all posts

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 ..