Oracle long datatype

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

gReaen
Profile Answers by gReaen Questions by gReaen
Dec 1st, 2007
9
3474

Questions by gReaen

SQL

Answer

Showing Answers 1 - 9 of 9 Answers

patilpravin_1981
Profile Answers by patilpravin_1981

Jan 29th, 2008

I think alter the table structure give antoher data type data typa -bLOB

krishnaindia2007
Profile Answers by krishnaindia2007

May 16th, 2008

If text is not visible use
SET LONG 2000.

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.