Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: create own datatypes

Re: create own datatypes

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Sep 2001 16:59:11 +0200
Message-ID: <tpf6fe15oobr75@news.demon.nl>

"Markus Kehrls" <Markus.Kehrls_at_Synnotech.de> wrote in message news:9n7vr2$60tj8$1_at_ID-5151.news.dfncis.de...
> Hello to all!
>
> Is there the possibility in oracle to create my own datatype (no objects
or
> records)?
> I want to do the following:
>
> create DTusername = varchar(30) //my own datatype
>
> Then i want to use DTusername for example in one table:
>
> create table test_table ( username DTusername );
>
> The advantage of this method is that everybody who create his table is
> using for username automatically varchar(30), and every table has the same
> type.
> In Sybase there is i think the possibility. in borlands interbase it works
> with create domain.
> I asked specialists, but nobody knows or they say it doesn't work.
>
> Thank you for answering,
> Markus
>
>
>

Two more or less political answers:
- In Designer 6i you can create domains which will be translated to native datatypes and synnched. As using Designer you should never ever create a table manually, in theory this is a viable solution for your need - On database level this is not (yet?) possible, presumably because it has been implemented in Designer and Oracle feels you should use (their) Case product, and not hack away and create tables on the fly (I have the feeling that is still the most common development method in the world, and I have seen often enough what comes from it: overtime, lack of sleep, in short a nightmare)

Regards,

Sybrand Bakker, Senior Oracle DBA

>
Received on Thu Sep 06 2001 - 09:59:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US