[oracle]自定义类型

    技术2022-05-11  53

    创建自定义类型create type room_capacity_type as object(auditorium_setting               integer,table_setting                          integer,standing_room_setting       integer) 

    表中使用create table t4(lot room_capacity_type)

    插入值insert into t4(lot) values(room_capacity_type(10,10,10));

    访问select a.lot.auditorium_setting,a.lot.table_setting,a.lot.standing_room_setting from t4 a;

     

     


    最新回复(0)