Usage of "long" in oracle database

[gReaen]

I'm trying to store a lengthy text in a table using oracle9i. I tried long datatype for the same. but when i tried to display the text using "select", it displays only 80 chars. Please help.......

[Michael Sync]

How come you want to store the characters in long datatype? it's not possible. If you want to store the lengthy text then you can use nvarchar() for that. Anyway, you are in wrong forum..

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)