database - Select * from table show multiple entries -

database - Select * from table show multiple entries -

when utilize select * table database shows this. why ? have 1 entry each column. shows repeated times.

you can specify line size , page size if necessary this:

set linesize 100 pagesize 50

you can alter value of linesize , pagesize according you.

or can seek this, works me of time

set lines 256 set trimout on set space 1 set tab off

database oracle11g