I'm using oracle9i to create a table which stores lyrics in long datatype. But if i store a long string of text and display it from the table, it displays only 80 chars. So someone help me how to store the whole lyrics txt file

ramyaselvi16

 Profile Answers by ramyaselvi16 Questions by ramyaselvi16

• Jun 24th, 2008

Variable length character values up to 2 gigabytes. Only one LONG column is allowed per table. You cannot use LONG datatype in functions, WHERE clause of SELECT, in indexing and subqueries.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

If text is not visible use SET  LONG  2000.

Answer Question  Select Best Answer