---
# System prepended metadata

title: PL/SQL 程式管理
tags: [大學部專題]

---

###### tags: `大學部專題`

# PL/SQL 程式管理

## 註解撰寫

[註解撰寫範例](https://www.thatjeffsmith.com/archive/2012/03/javadoc-for-the-database-a-la-dbdoc-via-sql-developer/)
    - 寫 Package 的註解
    - 寫 Public package variable 的註解
    - 使用 DB Doc tool 產生 API 文件。
    
[JavaDoc Template for PL/SQL Package](https://plsql-md-doc.readthedocs.io/en/latest/javadoc-template/)

[Comments Style](https://insum-labs.github.io/plsql-and-sql-coding-guidelines/v1.1/3-coding-style/02-coding-style-comments/)
- 使用 JavaDoc 的風格撰寫 function, procedure, package 的註解
- SQLDeveloper 提供工具產生 API doc.

[JAVADOC for the Oracle Database a la DBDOC](https://www.thatjeffsmith.com/archive/2012/03/javadoc-for-the-database-a-la-dbdoc-via-sql-developer/)
- 自動產生 API DOC
![](http://thatjeffsmith.wpengine.com/wp-content/uploads/2012/03/dbdoc2.png)

## 源始碼管理

[Using Source Code Control in Oracle SQL Developer](https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/srccodexmlext/srccode_otn.htm)

## Git 版本控管 

[Git 入門指南](https://backlog.com/git-tutorial/tw/intro/intro1_1.html)


## 產生 ERD

[使用 SQLDeveloper 產生 ERD](https://www.thatjeffsmith.com/archive/2011/11/how-to-generate-an-erd-for-selected-tables-in-sql-developer/)

![](https://hackmd.io/_uploads/rJ0Jr9gjh.png)
