Re: new data type or alias for NUMERIC(18)?

Mark Harrison wrote:
> I've got an application which deals with a bunch of
> asset identifiers, which should all be NUMERIC(18).
>
> Can I create a new data type or alias so that my
> table definitions, etc, show a type of ASSETID rather
> than NUMERIC(18)?
>
> Thanks!
> Mark

Assuming you are actually working in Oracle you can. NUMERIC(18) is not Oracle syntax.

A user defined data type is as simple as:

CREATE OR REPLACE TYPE ssn_t AS OBJECT ( ssn_type CHAR(11));
/

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)