Results as test, not a grid

[Michael John]

Is there a way to have the results of a query displayed in text as opposed to the grid? I am aware of the exporting feature, but having a columns aligned test out put would be helpful.
Thanks!

 

[Michael John]

I meant TEXT, not test. Sorry

 

[Marco Kalter]

The Command Window can do this:

SQL> select * from dept;

DEPTNO DNAME          LOC
------ -------------- -------------
    10 ACCOUNTING     NEW YORK
    20 RESEARCH       DALLAS
    30 SALES          CHICAGO
    40 OPERATIONS     BOSTON

SQL>

Is this what you are looking for?