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

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...