Use /g, \g, /G, \G to display fetch result vertically.

example:

select * from employees where rownum<3/g;

OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client.

30-day free trial

US$49.95