Skip to Main Content

SQL Developer Data Modeler

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!

I'd like it to create NVARCHAR(1) ...

EJNSep 11 2014 — edited Sep 12 2014

The oddest thing. I just used SQL Developer Datamodeler (4.0.2.840) to generate some DDL. This is the result (anonimized):

CREATE TABLE abcd.efgh

  (

    ID NUMBER NOT NULL ,

    aa1 NVARCHAR2 (2) ,

    aa2 NVARCHAR2 (8) ,

    aa3 NVARCHAR2 ,

    aa4 NVARCHAR2 (2) ,

    aa5 NVARCHAR2 (2) ,

    aa6 NVARCHAR2 ,

    aa7 NVARCHAR2 ,

    aa8 NVARCHAR2 ,

    aa9 NVARCHAR2 (3) ,

    aa0 NUMBER (15,7) ,

    SDDateIns DATE ,

    SDDateUpd DATE

  ) ;

As you can see, some of the NVARCHAR2 fields have a length specified, some don't. However, this is reverse engineerd from an MS-SQL table that has fields with VARCHAR datatypes that ALL have length specified. It seems that whenever the original length = 1, the generated DDL has no length specified. All other lengths are nicely specified. So I expected this result:

CREATE TABLE abcd.efgh

  (

    ID NUMBER NOT NULL ,

    aa1 NVARCHAR2 (2) ,

    aa2 NVARCHAR2 (8) ,

    aa3 NVARCHAR2 (1) ,

    aa4 NVARCHAR2 (2) ,

    aa5 NVARCHAR2 (2) ,

    aa6 NVARCHAR2 (1) ,

    aa7 NVARCHAR2 (1) ,

    aa8 NVARCHAR2 (1) ,

    aa9 NVARCHAR2 (3) ,

    aa0 NUMBER (15,7) ,

    SDDateIns DATE ,

    SDDateUpd DATE

  ) ;

Any ideas about what I'm doing wrong?

This post has been answered by Philip Stoyanov-Oracle on Sep 12 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2014
Added on Sep 11 2014
1 comment
1,240 views