Sqlplus doesnt print entire select output, while SQLdeveloper does

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.

Answers


Try running the query after setting the sqlplus session :

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

You can refer docs at the following link for more information: http://docs.oracle.com/cd/B10501_01/server.920/a90842/ch13.htm#1011230


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

set long 32767

Need Your Help

SwingWorker to run class that creates threads. Java

java multithreading user-interface swingworker

I have "Creator" class that has anonymous inner runnable class that creates threads. I also have GUI class that creates GUI and on button press executes the "Creator" class. But then my GUI freezes...

Array out of bounds?

c# arrays

I keep gettting array index out of bounds?