请教,这个Informix的表,如何用oracle建!!!

trampshi

CREATE TABLE student
(
s_name VARCHAR(30),
s_address ROW(street VARCHAR (20), city VARCHAR(20),state CHAR(2), zip VARCHAR(9))
);

oracle里有类似informix的行类型数据吗?
谢谢!

rollingpig

Oracle的 User define Object type

类似于：
  create or replace type obj_type is
object
(a number,b number);
SQL> /

Type created.



SQL> create table test_object(a obj_type);

Table created.

SQL> insert into test_object values(obj_type(1,2));

1 row created.

SQL> commit ;

Commit complete.

SQL> select * from test_object;

obj_type(A, B)
--------------------------------------------------------------------------------
obj_type(1, 2)