Sqlplus doesnt print entire select output, while SQLdeveloper does

Question

when i execute a query on SQLdeveloper

select text from dba_views where VIEW_NAME='EG_Name' and owner='user123';

I get the result

select
       col1,
       col2,
       col3,
       col4,
       col5  from Table1

but when i execute the same query on sqlplus i get a truncated output like

TEXT
--------------------------------------------------------------------------------
select
       col1,
       col2,
       col3,
       c
SQL>

for some reason it is being truncated?

Anyone have an idea.

Alex Poole · Accepted Answer · 2014-03-19 16:01:05Z

3

dba_views.text is data type long. You need to increase the default display size from the default 80 characters:

set long 32767

answered Mar 19, 2014 at 16:01

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you so much it worked! Stackoverflow is awesome!. You fixed this issue in 5 mins, which our team was trying to fix since 1 day.

Amit · Accepted Answer · 2014-03-19 15:56:29Z

1

Try running the query after setting the sqlplus session :

set pagesize 100;
set linesize 10000;
set num 20;

answered Mar 19, 2014 at 15:56

Amit

20.6k7 gold badges51 silver badges55 bronze badges