Friday, January 19, 2024

How to comment tables in oracle database ?

# How to comment oracle database #
---------------------------------------------------------------------------------------------------------
COMMENT ON TABLE your_table_name
IS 'This is a multi-line comment for your table.
It provides additional information about the table structure and purpose.';


SELECT table_name, comments
FROM all_tab_comments
WHERE table_name = 'your_table_name';

No comments:

Post a Comment

opatchauto

# Log in as root su - root # Execute opatchauto against the unzipped patch directory /u01/app/19.0.0/ grid /OPatch/opatchauto apply /tmp/pat...