# ORACLE SQLPLUS 產生CREATE 語法

set long 100000
set head off
set echo off
set pagesize 0
set verify off
set feedback off
select dbms_metadata.get_ddl('TABLE', 'TABLE NAME')
from dual;

## 實際效果


參考資料
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_metada.htm#ARPLS66871