1、desc命令

2、dbms_metadata.get_ddl函数

例如查看oracle.a1的表结构：

SQL> set serveroutput on;
SQL> DECLARE
2 TT varchar2(4000);
3 begin
4 tt := DBMS_METADATA.GET_DDL('TABLE','A1','ORACLE');
5 dbms_output.put_line(tt);
6 end ;
7 /

CREATE TABLE "ORACLE"."A1"
( "ID" VARCHAR2(10),
"NAME" VARCHAR2(10)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "ORATBS"

PL/SQL procedure successfully completed

SQL>
SQL> desc oracle.a1;
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
ID VARCHAR2(10) Y
NAME VARCHAR2(10) Y

SQL>

[@more@]

ITPub博客

两种查看oracle表结构的方法

最新文章