--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
Do i need to write in PL/SQL or is it possible in SQL query?
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
