Hi,
I have a table with 16000 rows in which one of the column data type is "long" type. I am unable to find the length of the characters stored in that particular column.
Also, When I tried to extract them , the data gets truncated and returns only a single char. So I used an ETL tool and extracted the data and placed in a text file.
I surely want to find length of the data stored in each particular field (in each 16000 rows) dynamically as i want to parse the data later.
Any help in showing the way is highly appreciated.
Thanking you'
RK
I have a table with 16000 rows in which one of the column data type is "long" type. I am unable to find the length of the characters stored in that particular column.
Also, When I tried to extract them , the data gets truncated and returns only a single char. So I used an ETL tool and extracted the data and placed in a text file.
I surely want to find length of the data stored in each particular field (in each 16000 rows) dynamically as i want to parse the data later.
Any help in showing the way is highly appreciated.
Thanking you'
RK
