Oracle 11g learn server result cache from MySQL's query cache, and extend it to client side result cache, this is really cool. But the SQL*Plus also need to run some thing from MySQL, I did learn from MySQL in AnySQL utility to display query result in form mode.
When query few rows with many columns, MySQL can add a "\G" option to display the result at form mode, such as the following.
mysql> select * from mt_entry where entry_id =673 \G;
*************************** 1. row ***************************
entry_id: 673
entry_allow_comments: 1
entry_allow_pings: 0
entry_atom_id: tag:www.anysql.net,2007://1.673
entry_author_id: 1
entry_basename: change_mt_blog_indexes
entry_blog_id: 1
entry_category_id: NULL
entry_convert_breaks: 0
entry_excerpt: NULL
entry_keywords: Blog, MT, Comment, Index, Tuning,
......
For security reasion, we are not allowed to connect from Notebood to the UNIX/Linux database servers, we are always using SQL*Plus to do the DBA jobs.
This feature should be added.