CODEWITHSUNDEEP
databaseoracle11g
Jithin Sebastian
Jithin Sebastian

Reputation: 581

Select * from table show multiple entries

when i use select * from table the database shows like this. Why is it so ? I have only one entry for each column. It shows repeated times.

Upvotes: 0

Views: 101

Answers (1)

ravi chaudhary
ravi chaudhary

Reputation: 625

You can specify the line size and page size if necessary like this:

set linesize 100 pagesize 50

you can change the value of linesize and pagesize according to you.

or you can try this, it works for me most of the time 

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

Upvotes: 2

Related Questions