如何把record table里的数据放到object table里
type rec is record(
item varchar2(30),
desc_ varchar2(50)
);
type t_rec is table of rec;
tt t_rec ;type obj is object(
item varchar2(30),
desc_ varchar2(50)
);
type b_rec is table of obj;
bb b_rec ;
现在tt里面有数据。我想把tt里的数据直接放到bb 里能实现么
type rec is record(
item varchar2(30),
desc_ varchar2(50)
);
type t_rec is table of rec;
tt t_rec ;type obj is object(
item varchar2(30),
desc_ varchar2(50)
);
type b_rec is table of obj;
bb b_rec ;
现在tt里面有数据。我想把tt里的数据直接放到bb 里能实现么
insert into object as select * from record;
---这样可以不?