June 2008

Reading CSV File Using C Program

June 2, 2008

Since I’m on an integration project, I’m mostly dealing with transferring of data from two or more systems whether it’s from the legacy system or newly implemented system. Most of the type of data movement is sending CSV files to and from the different system. Here is a simple tutorial on how to read CSV. [...]

Read the full article →

Validating Numeric and Non-Numeric Values

June 2, 2008

To check if numeric and non-numeric values, the following syntax can be use. Syntax PLAIN TEXT CODE: select DECODE( TRANSLATE(<value here>,'0123456789',' '), NULL, 'Numeric','Character')  from dual; Example PLAIN TEXT CODE: select DECODE( TRANSLATE('12345Z','0123456789',' '), NULL, 'Numeric','Character')  from dual; The example above will return 'Character' because the value has non-numeric characters.

Read the full article →