Re: Designer 2000 Question
Date: 1996/03/10
Message-ID: <NEWTNews.826530134.17888.elric_dm_at_dialup.netvision.net.il>#1/1
In Article<4hj6u5$16f_at_newsbf02.news.aol.com>, <paul821_at_aol.com> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!news-e2a.gnn.com!newstf01.news.aol.com!newsbf02.news.aol.com!not-for-mail
> From: paul821_at_aol.com (Paul821)
> Newsgroups: comp.databases.oracle
> Subject: Designer 2000 Question
> Date: 6 Mar 1996 00:13:41 -0500
> Organization: America Online, Inc. (1-800-827-6364)
> Lines: 11
> Sender: root_at_newsbf02.news.aol.com
> Message-ID: <4hj6u5$16f_at_newsbf02.news.aol.com>
> Reply-To: paul821_at_aol.com (Paul821)
> NNTP-Posting-Host: newsbf02.mail.aol.com
>
> When defining attributes with in an entity, I use the format of
> "CHAR". However when I generate the table definition, it comes up as
> VARCHAR2. I can later change the format again on the table back to CHAR,
> prior to generating the DDL. I want it to stay CHAR when I originally set
> it in the attributes, and not have to remember to reset it in the table
> definition each time prior to generating the DDLs.
> Does anyone know
> how to get around this problem another way?
>
> Paul821_at_aol.com
>
try setting a domain and in the domain set the column
data-type to char, since the datatype from the domain is used for the
column you should be "home free"
Received on Sun Mar 10 1996 - 00:00:00 CET