17,086
社区成员
发帖
与我相关
我的任务
分享
create table TEST
(
TESTID varchar(10) not null, --编号
TESTNAME varchar(50) default '', --名称
REMARK varchar(150) default '', --备注
primary key (TESTID)
)
select * from sys.user_tab_columns a where a.table_name='TEST'
select * from user_constraints uu where uu.table_name='TEST'
SELECT a.TABLE_NAME,
a.TABLESPACE_NAME,
b.COLUMN_NAME,
b.DATA_TYPE,
b.DATA_PRECISION,
b.DATA_SCALE,
c.comments
FROM user_tables a, user_tab_columns b, user_col_comments c
WHERE a.TABLE_NAME = b.TABLE_NAME
AND a.TABLE_NAME = c.table_name
AND b.COLUMN_NAME = c.column_name
AND a.TABLE_NAME = upper('&table_name');
select t.TABLE_NAME,t.COLUMN_NAME,t.DATA_TYPE,t.DATA_LENGTH from user_tab_columns t where t.TABLE_NAME='SYS_TEST'
select column_name,data_type,data_length,data_precision,data_scale
from user_tab_columns where table_name='EMP';
COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION DATA_SCALE
------------------------------ ------------------------------- ----------- -------------- ----------
EMPNO NUMBER 22 4 0
ENAME VARCHAR2 10
JOB VARCHAR2 9
MGR NUMBER 22 4 0
HIREDATE DATE 7
SAL NUMBER 22 7 2
COMM NUMBER 22 7 2
DEPTNO NUMBER 22 2 0