6 responses

  1. Kent Graziano
    March 22, 2013

    Another point about comments in the database – most (if not all) modern reporting and BI tools read comments in the Oracle data dictionary into the various meta layers. This is hugely helpful to folks doing “self-service” BI and need to build useful reports with meaningful business meta data that end users relate to.

    And who does not run reports on their database? Your comments WILL get used. So, just do it!

  2. Mayo Fadelu
    June 25, 2013

    Jeff: I have a question about how to include comments to a table in SQL developer. The comments basically explains what the table does. There are some of the tables I am working on that already have comments, however a lot of them don’t have any.
    Example: Table — FIXBADID with OWNER: TT_EAS. I was wondering what the query will be to include comment to this table. Thanks

    • thatjeffsmith
      thatjeffsmith
      June 25, 2013

      You want a query to get the comments, or you want the ALTER syntax to ADD them when they’re missing?

      • Mayo Fadelu
        June 25, 2013

        I want to ALTER syntax to ADD them when they’re missing. I saw this query on Oracle but I wasn’t sure if it also works with SQL developer. The query is below
        COMMENT ON TABLE “TABLE NAME”
        IS
        ‘COMMENTS.';

        Thanks

      • thatjeffsmith
        thatjeffsmith
        June 25, 2013

        column comment example

        comment on column "HR"."BEER"."CITY" is 'Corporate is at HQ'
        

        You can of course use SQL Developer to add the comments to the tables and their columns. Just find the table in the browser and right-click on it :)

      • Mayo Fadelu
        June 25, 2013

        I used the COMMENT ON TABLE “TABLE NAME”
        IS
        ‘COMMENTS.’;. It worked. Thanks so much for your help.

Leave a Reply

 

 

 

Back to top
mobile desktop