Oracle Database Discussions

Hi,

Sample table for testing:

create table comment_test (id number);

When trying to add comment to table with "double quotation"

comment on table comment_test is "table for testing unconditional multi insert";

I get "ORA-00972: identifier is too long"

but when replacing double quotation with single quotation mark it runs successfully.

comment on table comment_test is 'table for testing unconditional multi insert'

Can anyone explain the magic of it?

I am testing it in 64 bit Windows, Oracle Express Edition.