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
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.