SQL> desc dept; 名称 空? 类型 ----------------------------------------- -------- --------------------- DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13)SQL> col tname format a10 SQL> col cname format a10 SQL> select tname,cname,coltype,width from col where tname=upper('dept');TNAME CNAME COLTYPE WIDTH ---------- ---------- -------------------- ---------- DEPT DEPTNO NUMBER 22 DEPT DNAME VARCHAR2 14 DEPT LOC VARCHAR2 13SQL>
以 user_ 开头的
all_ 开头的
dba_ 开头的
名称 空? 类型
----------------------------------------- -------- ---------------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)SQL> col tname format a10
SQL> col cname format a10
SQL> select tname,cname,coltype,width from col where tname=upper('dept');TNAME CNAME COLTYPE WIDTH
---------- ---------- -------------------- ----------
DEPT DEPTNO NUMBER 22
DEPT DNAME VARCHAR2 14
DEPT LOC VARCHAR2 13SQL>