SQL> desc emp; Name Type Nullable Default Comments -------- ------------ -------- ------- -------- EMPNO NUMBER(4) ENAME VARCHAR2(10) Y JOB VARCHAR2(9) Y MGR NUMBER(4) Y HIREDATE DATE Y SAL NUMBER(7,2) Y COMM NUMBER(7,2) Y DEPTNO NUMBER(2) Y
嗯,你的desc是写在sql plus中,是能看到了,那么写在sql plus worksheet中还是没有,请问在plus worksheet中怎么显示呢
用命令看 select a.table_name, a.column_name, a.comments, b.DATA_TYPE from user_col_comments a, user_tab_columns b where a.table_name = b.TABLE_NAME and a.column_name = b.COLUMN_NAME;
在sql plus worksheet中还是没有,请问在plus worksheet中怎么显示
你再加个条件啊 。 select a.table_name, a.column_name, a.comments, b.DATA_TYPE from user_col_comments a, user_tab_columns b where a.table_name = b.TABLE_NAME and a.column_name = b.COLUMN_NAME and a.table_name='TABLENAME'; 大写表名
select a.table_name, a.column_name, a.comments, b.DATA_TYPE from user_col_comments a, user_tab_columns b where a.table_name = b.TABLE_NAME and a.column_name = b.COLUMN_NAME and a.table_name='scott.emp';未选定行还有我执行了 select * from user_col_comments 一直执行,怎么让它停下来呢
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
EMPNO NUMBER(4)
ENAME VARCHAR2(10) Y
JOB VARCHAR2(9) Y
MGR NUMBER(4) Y
HIREDATE DATE Y
SAL NUMBER(7,2) Y
COMM NUMBER(7,2) Y
DEPTNO NUMBER(2) Y
select a.table_name, a.column_name, a.comments, b.DATA_TYPE
from user_col_comments a, user_tab_columns b
where a.table_name = b.TABLE_NAME
and a.column_name = b.COLUMN_NAME;
select a.table_name, a.column_name, a.comments, b.DATA_TYPE
from user_col_comments a, user_tab_columns b
where a.table_name = b.TABLE_NAME
and a.column_name = b.COLUMN_NAME
and a.table_name='TABLENAME';
大写表名
from user_col_comments a, user_tab_columns b
where a.table_name = b.TABLE_NAME
and a.column_name = b.COLUMN_NAME
and a.table_name='scott.emp';未选定行还有我执行了
select * from user_col_comments 一直执行,怎么让它停下来呢