SQL Language (MOSC)

MOSC Banner

Muliple columns - Comment on Column Syntax

edited Oct 13, 2011 4:16AM in SQL Language (MOSC) 3 commentsAnswered
I can not locate an example of the COMMENT ON COLUMN where multiple columns are effectd for a single table - WITHOUT HAVING TO REPEAT the table's name.

So, just a quick check to find out if it can be done, and then an example of adding two or more column comments without table name repeat iteration.

I understand this works, but trying to eliminate repeat of table name:

Comment on column (TABLE_NAME.Column1 is 'First Column';

Comment on column (TABLE_NAME.Column2 is 'Second Column';

I am trying to avoid repeating "Comment on column (TABLE_NAME. So I am looking for something more efficient, something more like

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center