Help: how to use 'LONG' type?
From: GM <mng3_at_hotmail.com>
Date: 1997/08/06
Message-ID: <33E83364.212C_at_hotmail.com>#1/1
Date: 1997/08/06
Message-ID: <33E83364.212C_at_hotmail.com>#1/1
I want to save a long string in a table, someone told me to use "LONG"
type which is up to 2 gigabyte.
I tried like this:
create table test_long ( id number,
content long);
insert into test_long values(1,'xxx..........xxxxx')
but failed, if the string is more than 2000 byte, the error arises:
ORA-01704: string literal too long
Why?!
Received on Wed Aug 06 1997 - 00:00:00 CEST
