After some research of MySQL, Yong Huang gave me a excellent advice to add a new feature in AnySQL, to display in the form mode other than grid mode. This feature is very useful when display few rows with lots of columns. Let's get some objects for testing.
ASQL> select * from tab where rownum < 5;
TNAME TABTYPE CLUSTERID
---------- ------- ---------
BONUS TABLE
CLU_A CLUSTER
CR_5043802 TABLE
DEPT TABLE
4 rows returned.
Then we are required to display the object information from table "USER_OBJECTS", by adding one of patterns ("/g","/G","\G","\g") to the standard select statement, the row will be displayed in form mode. As following.
ASQL> select * from user_objects where object_name='BONUS'/g;
OBJECT_NAME : BONUS
SUBOBJECT_NAME : null
OBJECT_ID : 637961
DATA_OBJECT_ID : 637961
OBJECT_TYPE : TABLE
CREATED : 2007-05-16 22:03:27.0
LAST_DDL_TIME : 2007-05-16 22:03:27.0
TIMESTAMP : 2007-05-16:22:03:27
STATUS : VALID
TEMPORARY : N
GENERATED : N
SECONDARY : N
1 rows returned.
Download patch if you want to enjoy it!