Re: [Q]: Entering a carriage return into a LONG column using SQL*Plus
From: Sarabjeet Singh <sasingh_at_us.oracle.com>
Date: 1995/06/05
Message-ID: <3qtlih$aj3_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1995/06/05
Message-ID: <3qtlih$aj3_at_inet-nntp-gw-1.us.oracle.com>#1/1
the following should work:
INSERT INTO MASTER_TABLE
VALUES (1, 'This is first line' ||
chr(10) ||
'This is line two');
sarab.
- standard disclaimer applies ----