oracle查看表结构6,两种查看oracle表结构的方法

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@]