Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: create own datatypes
"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
![]() |
![]() |