Oracle 中dba_tab_columns 表的小小用法用于Excel 导出数据库

select * from dba_tab_columns where owner='EAST' and table_name='USERS';

 

owner 为当前的表空间名 

table_name 为表的名称（注意这是全大写）

 

 

 

COLUMN_NAME                    DATA_TYPE                                                                                                 
------------------------------ ----------------------------------------------------------------------------------------------------------
ID                             NUMBER                                                                                                    
NAME                           VARCHAR2                                                                                                  
OBJECTFULLNAME                 VARCHAR2                                                                                                  
LOGINTIME                      DATE                                                                                                      
PASSWORD                       VARCHAR2                                                                                                  
USERNAME                       VARCHAR2                                                                                                  
ROLE_ID                        NUMBER