How to handle field data type varchar2(4000)
Posted: Fri May 12, 2017 2:22 pm
Hi,
I am reading the data from Oracle database and creating file(same process for around 100 tables).these are 1 to 1 straight mappings,So i am using schema files. i have one table having 3 columns but last column datatype is Varchar2(4000). but when i am trying to write the records in files, record is splitting into more than 1 record. i think it looks because of varcha2(4000), we are facing this issue. that filed having spaces between words and some space at the end also. data not splitting into different record, but new record creating with space. please let me know how to create the record in file without having issue.
Thanks in Advance..
I am reading the data from Oracle database and creating file(same process for around 100 tables).these are 1 to 1 straight mappings,So i am using schema files. i have one table having 3 columns but last column datatype is Varchar2(4000). but when i am trying to write the records in files, record is splitting into more than 1 record. i think it looks because of varcha2(4000), we are facing this issue. that filed having spaces between words and some space at the end also. data not splitting into different record, but new record creating with space. please let me know how to create the record in file without having issue.
Thanks in Advance..