When I start to learn MySQL database, I feel Oracle SQL*Plus should learn from MySQL to display the result as form style. It's not implemented in Oracle 11g's SQL*Plus, but you are still lucky because I implement it in AnySQL utility. The same with MySQL, just put "/g", "/G", "\g" or "\G" at the end of SQL query.
For example:
ASQL> set driver oci
Oracle driver set to : oci
ASQL> conn system/oracle
Database connected.
ASQL> select * from v$database /g;
DBID : 25283465
NAME : DB10G
CREATED : 2007-09-10 17:11:37.0
RESETLOGS_CHANGE# : 1
RESETLOGS_TIME : 2007-09-10 17:11:37.0
PRIOR_RESETLOGS_CHANGE# : 0
PRIOR_RESETLOGS_TIME : null
LOG_MODE : NOARCHIVELOG
CHECKPOINT_CHANGE# : 1698916
ARCHIVE_CHANGE# : 1641202
......
It become a hot feature for me now.