---
# System prepended metadata

title: ORACLE SQLPLUS 產生CREATE 語法
tags: [sqlplus, ORACLE]

---

# 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://hackmd.io/_uploads/SJQIrTO2n.png)


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


