databaseoracle-databaseplsql

Does comment syntax exist for Oracle stored procedures?

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 stored procedure?

CREATE OR REPLACE PROCEDURE foo_user.bar_store_prod IS
BEGIN
    dbms_output.put_line('Welcome ' || 'foo');
END;
/
Solution

  • No.

    As per the documentation (21c, the latest version), a comment may only be added to the following entities: