Friday, 2 December 2011

Direct DB Request and Integer Problem on Column Selected

Sometimes when you do a direct database Request especially from Oracle you have problems when a number to obiee is an integer

Do the below to resolve .. In your sql statement CAST(yourcolumn AS double precision)

To change integer into double precision ---

select CAST(yourcolumn AS double precision)
from Yourtable

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...