Welcome to oracle_awen's archive blog
SQL> col object_name for a30
SQL> /

OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
A1        TABLE
A2        TABLE
A3         TABLE
UP_TEST          TABLE
OB_BAK         TABLE
OB_BAK2          TABLE
TEMP_UP           TABLE
OB_INDEX           INDEX
AFTER_COM            TABLE
UP_TEMP           TABLE
OB_COM            TABLE

OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
OVER_COM              TABLE
OB_VIEW             VIEW

已选择13行。

SQL> l
1* select object_name,object_type from dba_objects where owner=upper('awen')
添加评论

昵称 *

E-mail (防止垃圾信息,此栏留空)