I'm migrating an application from sql server to oracle.

We have tables with column that use user defined data type, for
example

CREATE TABLE AA (
Column1 CODE
)

Where CODE is defined as varchar(50)

Is there a way to create an equivalent CODE in oracle ?

On Jan 17, 9:20*am, alberto.rol... (AT) gmail (DOT) com wrote:
Yes, Oracle had this feature since version 8.0.

Read the following:
Oracle version# Application Developers Guide - Fundamentals
Application Developers Guide - Object-Relational Features
SQL Manual entry CREATE TYPE
PL/SQL User's Guide and Reference -- contains many examples of using
object types

HTH -- Mark D Powell --

On Jan 17, 9:20*am, alberto.rol... (AT) gmail (DOT) com wrote:
Yes, Oracle had this feature since version 8.0.

Read the following:
Oracle version# Application Developers Guide - Fundamentals
Application Developers Guide - Object-Relational Features
SQL Manual entry CREATE TYPE
PL/SQL User's Guide and Reference -- contains many examples of using
object types

HTH -- Mark D Powell --

On Jan 17, 9:20*am, alberto.rol... (AT) gmail (DOT) com wrote:
Yes, Oracle had this feature since version 8.0.

Read the following:
Oracle version# Application Developers Guide - Fundamentals
Application Developers Guide - Object-Relational Features
SQL Manual entry CREATE TYPE
PL/SQL User's Guide and Reference -- contains many examples of using
object types

HTH -- Mark D Powell --

On Jan 17, 9:20*am, alberto.rol... (AT) gmail (DOT) com wrote:
Yes, Oracle had this feature since version 8.0.

Read the following:
Oracle version# Application Developers Guide - Fundamentals
Application Developers Guide - Object-Relational Features
SQL Manual entry CREATE TYPE
PL/SQL User's Guide and Reference -- contains many examples of using
object types

HTH -- Mark D Powell --

hello, thanks. I've already tried it, but it seems to me that it can
"only" create complex types, something like struct in C++.

And to use them, I have to use a "constructor" in the insert
statement.

I need to be able to do only something like

insert into table AA (column1) values ('this is a string with maximum
50 chars')

and not something like

insert into table AA (column1) values (CODE('this is a string with
maximum 50 chars'))

Maybe I missed something on the create type syntax ?

thank you very much!

hello, thanks. I've already tried it, but it seems to me that it can
"only" create complex types, something like struct in C++.

And to use them, I have to use a "constructor" in the insert
statement.

I need to be able to do only something like

insert into table AA (column1) values ('this is a string with maximum
50 chars')

and not something like

insert into table AA (column1) values (CODE('this is a string with
maximum 50 chars'))

Maybe I missed something on the create type syntax ?

thank you very much!

hello, thanks. I've already tried it, but it seems to me that it can
"only" create complex types, something like struct in C++.

And to use them, I have to use a "constructor" in the insert
statement.

I need to be able to do only something like

insert into table AA (column1) values ('this is a string with maximum
50 chars')

and not something like

insert into table AA (column1) values (CODE('this is a string with
maximum 50 chars'))

Maybe I missed something on the create type syntax ?

thank you very much!

hello, thanks. I've already tried it, but it seems to me that it can
"only" create complex types, something like struct in C++.

And to use them, I have to use a "constructor" in the insert
statement.

I need to be able to do only something like

insert into table AA (column1) values ('this is a string with maximum
50 chars')

and not something like

insert into table AA (column1) values (CODE('this is a string with
maximum 50 chars'))

Maybe I missed something on the create type syntax ?

thank you very much!

<alberto.roller (AT) gmail (DOT) com> wrote



hello, thanks. I've already tried it, but it seems to me that it can
"only" create complex types, something like struct in C++.

And to use them, I have to use a "constructor" in the insert
statement.

I need to be able to do only something like

insert into table AA (column1) values ('this is a string with maximum
50 chars')

and not something like

insert into table AA (column1) values (CODE('this is a string with
maximum 50 chars'))

Maybe I missed something on the create type syntax ?

thank you very much!

What problem are you trying to solve? From your example, it would have been
better to just do varchar2(50) instead of creating a type of varchar2(50).
From your question I assumed that you were giving a trivial example, and
wanted the equivalent of a class or struct. (eg a type with multiple slots
or members). If you only need primitive types use the primitive types that
Oracle supplies and don't redefine them. So the answer is yes, if you want
to use types you have to use a constructor. If you look at the docs more
you will see that you can make the type more like a class, with a variety of
constructors and member functions etc. (Which is why you need to use a
constructor.)
Jim