No column comments in Single Record View

[bro]

I don't see any column comments in Single Record View.
Version 11.0.3.1770

Example:

create table test (i integer);
comment on column test.i is 'hello';
select * from user_col_comments where table_name = 'TEST';

TABLE_NAME      COLUMN_NAME  COMMENTS   ORIGIN_CON_ID
--------------- ------------ ---------- -------------
TEST            I            hello                  3

No comments in Single Record View for above table.

 

[Marco Kalter]

Works fine for me. Does the comment show on the status bar in Multi Record View?

 

[bro]

No.
Same for data type if Object Browser -> Show datatypes is enabled. No data type is displayed.

 

[bro]

Solved.

SQL Window -> "Show Dictionary Info In Result Grid" must be set to display column comments in Single and Multi Record View.

 

[minkmink999]

Thanks, in advance, for any info.

ร่วมเล่นสนุกๆไปกับพวกเรา ได้ที่นี่ คาสิโนออนไลน์