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..
