Oracle碎碎念~2
时间:2022-03-14 02:55
1. 如何查看表的列名及类型
SQL> select column_name,data_type,data_length from all_tab_columns where owner=‘SCOTT‘ and table_name=‘EMP‘; COLUMN_NAME DATA_TYPE DATA_LENGTH --------------- ---------- ----------- EMPNO NUMBER 22 ENAME VARCHAR2 10 JOB VARCHAR2 9 MGR NUMBER 22 HIREDATE DATE 7 SAL NUMBER 22 COMM NUMBER 22 DEPTNO NUMBER 22 8 rows selected.