Hi,

 

My company have a Oracle9i database ...One of the field (text) in this
database is a text file (VARCHAR2) with a length of 100
characters.....The text inside this field is "carriage return" return. 

 

When we retrieve this field (select text from db.text_field), it only
shows the first line. The second and the rest of the line does not show
up. Can I know how to I retrieve all the lines in this field?

 

Thanks..

 

Reply via email to