Dispaly LONG column in SQL*PLUS ?

[mahoori]

Hi all.

How i can display long column correctly(All content) in SQL*PLUS.
for example :
SQL> select trigger_name,trigger_body from user_triggers where trigger_name='MYTRIGGER';
Which setting in SQL*PLUS needed?

Sorry for my english!!!
Best Regards.

[jmodic]

Use

SET LONG 1000

which will allow you to get first 1000 characters of long column. Use whatever value suits your needs. I belive the default setting is 80.

[mahoori]

Hello modic.
Thank you for reply.