How do I create a comment on column with multiple blank lines.
I could able to do it through Toad.
However, when I migrate, DBA's do it through Unix and call my script file.
It is failing after creating table and exactly at comment on columns with multiple blank lines.
It did not fail for the columns that have comments with multiple lines but no blank lines.
CREATE TABLE TEST_CMNT(
NO NUMBER(5))
/
COMMENT ON COLUMN TEST_CMNT.NO IS 'Test column comment
Line 4
Line 5
Line 8
End commenting'
/
How do I comment on columns with multiple blank lines.
Appreciate your help
Regards