comment on objects

[Akila]

Hi,

Like we comment on tables and columns , is there a way to make a comment on procedure or function , do we have a dictionary like dba_tab_comments for the procedures, is this possible?.

Thank you,

Akila

[slimdave]

Oracle doesn't supply one, but there's no reason why you couldn't just create your own -- not in the SYS schema, of course.

[Akila]

how u make a write comment on the procedures ...can u plz explain me how i can do that..

[ICEMAN77]

simply make a comment on the procedure,function or package spec on top lines.
if you would make a single line use -- like
-- this is my comment

or if you would make more lines use /* */ like
/* this is
multiple line
comments */


bye
marco

[Akila]

no no iam not asking that i mean to ask comment on object level like u say "comment on table ....." for tables...is there a way to do it for procedures...

[padders]

Which bit of "Oracle doesn't supply one" isn't clear?