Insert into your column of table like this: 'text first line' || chr(13) || 'text next line'
Reading whether text has carriage return: instr( column_name,chr(13))>0; Disclaimer: in Oracle - not sure about the rest. David -----Original Message----- From: [Alan Leung] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 11:49 AM To: [EMAIL PROTECTED] Subject: Carriage return for Oracle Well, although it's a bit off topic, but what I want is to enter a carriage return in a insert statement when I do a DML statement in Oracle but not servlet-wise. =========================================================================== It really depends on the language you are using to interpret the results from the database. For example, if you include a <br> (i.e. 1st line<br>2nd line<br>3rd line<br>) and display the results from the query in HTML, you should get a display of: 1st line 2nd line 3rd line Replace <br> in this concept with whatever is a new line character delimiter in the language you are using to display the results. -----Original Message----- From: [Alan Leung] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: Carriage return for Oracle Hi all, Does anyone know how to insert a carriage return for a char type in a Oracle command statement? Example: Insert into <tablename> values (1,'1st line 2nd line 3rd line'); Thanks all =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com