Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wishlist. DESC TABLE, emit both the table & column comments.

DataProcessing6 days ago

When issuing several DESC TABLE_NAME in succession, one cannot tell which DESC output pertains to which table.

Add a both table & column comments. Verify they're present in the SQL DDL.

COMMENT ON COLUMN "NEO"."AQM_TYP"."FK_STR" IS 'The data type';
COMMENT ON TABLE "NEO"."AQM_TYP" IS 'Use case input Data Types for Bag.Pair';

Execute the command: desc AQM_TYP;

Name Null? Type
------ -------- ---------
PK_TYP NOT NULL NUMBER(9)
FK_STR NUMBER(9)

Neither table name, pr column comments printed.

Please consider adding the COMMENT attributes in the output.

This post has been answered by thatJeffSmith-Oracle on Nov 17 2025
Jump to Answer
Comments
Post Details
Added 6 days ago
1 comment
61 views