This discussion is archived
1 Reply Latest reply: Oct 16, 2012 3:39 PM by MahaYS-Oracle RSS

What is the maximum number of columns that can be displayed by sqlplus?

MahaYS-Oracle Journeyer
Currently Being Moderated
Hello,

Questions:
Is there a limit on what sqlplus can display?
What is the maximum number of columns that can be displayed by sqlplus?

I cannot find anything on this in my search. I checked the limits page:
http://docs.oracle.com/cd/B19306_01/server.102/b14357/apa.htm#sthref3658
http://docs.oracle.com/cd/E11882_01/server.112/e16604/apa.htm#i635278

It does not specify any column limits; however, I'm thinking it is tied to LINESIZE which is system dependent.

Please confirm if true.

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points