[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] Retrieve text from Oracle Text
From:       "Choy, Wai Yew" <waiyew.choy () ap ! att ! com>
Date:       2006-10-16 12:43:49
Message-ID: 5366ADA89F85114D9012AAAE603B5FB3AC06E5 () ausydmsx01 ! ap ! att ! com
[Download RAW message or body]


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

 



[prev in list] [next in list] [prev in thread] [next in thread]