Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to convert varchar2 into decimal

868712Dec 21 2011 — edited Jan 23 2012
Hi,

I need to convert source sybase varchar2 record in to decimal record in Target DB2 table by using the function in Oracle data integrator.

In my source table, column is defined as varchar2 (4) and in target table same column has defined as Decimal (2). So, is there any function to convert the varchar2 data to decimal record.

thanks,
keshav.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2012
Added on Dec 21 2011
3 comments
341 views