1

In sqlplus from Oracle XE Client 10,
I want to run select * from t_abc where rownum<11 on sqlplus

I planned to save the result into a text file that I can view with a text viewer. I've learned about spool and set pagesize 10000. If each record stays in a single line, reading it in a text editor would be no problem.

However, this doesn't work well as the output I got are broken into many lines each within the command-line window's width. This is not readable at all.

I'm looking for a way that can make each record stay in one line. Or something like \G in mysql. Anyway, it's ok as long as it makes it readable.

Haozhun
  • 267
  • 2
  • 5
  • 10

1 Answers1

4

Try:

set linesize 200

Or whatever length of line will work to make the output fit on one line per row.

Mike Scott
  • 8,228