00050.Oracle格式化输出

SQL> desc  all_objects;

 Name                                     Null?    Type

 ------------------------------------------------- ----------------------------

 OWNER                                     NOT NULL VARCHAR2(30)

 OBJECT_NAME                               NOT NULLVARCHAR2(30)

 SUBOBJECT_NAME                                    VARCHAR2(30)

 OBJECT_ID                                 NOT NULLNUMBER

 DATA_OBJECT_ID                                     NUMBER

 OBJECT_TYPE                                       VARCHAR2(19)

 CREATED                                   NOT NULLDATE

 LAST_DDL_TIME                             NOT NULL DATE

 TIMESTAMP                                          VARCHAR2(19)

 STATUS                                            VARCHAR2(7)

 TEMPORARY                                         VARCHAR2(1)

 GENERATED                                         VARCHAR2(1)

 SECONDARY                                          VARCHAR2(1)

 NAMESPACE                                 NOT NULLNUMBER

 EDITION_NAME                                      VARCHAR2(30)

SQL> col  object_name for a12

SQL> col  object_type for a10

SQL> select  owner,object_name,object_id,created,status from all_objects whereowner='imuse01';