Retrieve text from Oracle Text
| From: | Choy, Wai Yew | Date: | Mon, 16 Oct 2006 12:43:49 +0000 |
| Subject: | Retrieve text from Oracle Text | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42566@lists.php.net to get a copy of this message | ||
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..