create table TEST0731
(
test1 VARCHAR2(30)
)
create table TEST0732
(
test4 VARCHAR2(30),
test5 VARCHAR2(30),
test6 VARCHAR2(30)
)
insert into TEST0731 (test1)
values (‘TEST4’);
insert into TEST0731 (test1)
values (‘TEST5’);
insert into TEST0731 (test1)
values (‘TEST6’);
commit;
insert into TEST0732 (test4, test5, test6)
values (‘1’, ‘2’, ‘3’);
commit;
通过 TEST0731的结果变成TEST0732的列名来 查询 TEST0732 的结果
==>
结果就是: select * from TEST0732 的结果,但是 不能体现 * 查询,要用TEST0731的列表的值来实现