[Oracle/sql]查看当前用户名下有多少表 以及查看表字段信息
SQL> select table_name from user_tables order by table_name; TABLE_NAME ------------------------------ BIGTABLE COURSE EMP HY_MILLION HY_MILLION2 SCORE SMALLTABLE STUDENT TB_100MILLION TB_COURSE TB_DEPT03 TB_EMP01 TB_EMP02 TB_EMP03 TB_EMP04 TB_MILLION TB_SC TB_SCORE TB_SCORE01 TB_SCORE2 TB_SCORE3 TB_SC_NODUP TB_SC_NODUP2 TB_STUDENT TB_TENMILLION TEST01 TEST02 TEST03 TEST04 TESTCOUNT 已选择30行。 SQL> desc testcount; 名称 是否为空? 类型 ----------------------------------------- -------- ---------------------------- NAME NVARCHAR2(60) VAL NVARCHAR2(60) SQL>