top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to add Comments on table and columns in Oracle?

+1 vote
248 views
How to add Comments on table and columns in Oracle?
posted May 11, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

--For documentation purpose .
Comment table a is ‘table a’ ; Retrieve comment from user_tab_comment
Comment column a. a is ‘column a’; user_col_comments

answer May 12, 2015 by Arun Gowda
Similar Questions
+1 vote

Do i need to write in PL/SQL or is it possible in SQL query?

+1 vote

I am using below statement but i got error.
ALTER TABLE XXXtable
ADD xxx_name varchar2(50) not null;

error message:
ORA-01758: table must be empty to add mandatory (NOT NULL) column

...