[Q]: Entering a carriage return into a LONG column using SQL*Plus

From: Rashpal Singh <rsingh_at_ix.netcom.com>
Date: 1995/06/04
Message-ID: <3qre93$aee_at_ixnews4.ix.netcom.com>#1/1

If I have a table:

MASTER_TABLE

  ID          NUMBER
  TEXT        LONG

and I needed to insert following data into this table (which includes carriage returns, denoted as <CR> in my insert statement below:

INSERT INTO MASTER_TABLE
VALUES (1, 'This is first line' ||
<CR>
'This is line two');

The only problem is that when i enter a Return, SQL*Plus stops prompting for additional lines. How can I get around this problem? Is there an escape character I can use to escape the Return ?

Thanks for any suggestions/comments. Received on Sun Jun 04 1995 - 00:00:00 CEST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]