Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, functions, packages and types. However, I can't find any documentation for it, describing what syntax I should use.
I have worked out that I should use a /* ... */
comment on the line(s) immediately above my procedure/whatever, and (by borrowing from JavaDoc) I have successfully used @param
and @returns
statements, but I'm not sure what else I can use. For example, are there fields for author, version, data modified, etc.?
I've done numerous searches of this site, Google, and Oracle's documentation, to no avail!
Best Answer
Community wiki answer initially based on comments left by thatjeffsmith:
This is an exhaustive list of what it supports:
(reproduced from http://pldoc.sourceforge.net/maven-site/samples/sample1.sql)
We support everything in PLDOC - we just have a GUI vs a CLI for it. There are three code samples there, you should be able to do anything listed in those samples.