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.