As table, I have
CREATE TABLE foo_tbl
(
COLUMN1 VARCHAR2(20)
);
COMMENT ON TABLE foo_tbl 'For look up.';
Is exist comment syntax for Oracle store procedure?
CREATE OR REPLACE PROCEDURE foo_user.bar_store_prod IS
BEGIN
dbms_output.put_line('Welcome ' || 'foo');
END;
/
CodePudding user response：
No.
As per the documentation (21c, the latest version), a comment may only be added to the following entities:
- table
- view (materialized or not)
- column
- audit policy
- edition
- indextype
- mining model
- operator
CodePudding user response：
Does not exist comment syntax for Store procedure.