Book a Demo

Author Topic: Code generation - DDL  (Read 1996 times)

terencef

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Code generation - DDL
« on: October 01, 2004, 02:11:16 pm »
Hi; first off...this tool is awesome .... I've only ben using it for a month for documentation purposes, and last week we started generating DDL's for Oracle.

There is a minor bug when comment level is set to "ALL";

CREATE TABLE Contact_Type (
     ContactTypeId NUMBER(8) NOT NULL,    --  PK
     ContactType_Descr VARCHAR2(50),    --  The descriptive name of the Contact Type. Example: Home Phone, Cell Phone Pager etc
)
;
COMMENT ON TABLE Contact_Type
   IS 'This table is a look up table that has all the contact types e.g. Phone1 Phone2 Email etc'

notice the extra comma after the last column. Also noticed that this is a random issue and does not happen for every table...

If you turn off comments, the DDL is syntactically correct...

Thanks in advance for a great product..