Question

初学者求解答：使用PLSQL连接oracle，如何给2个表建立视图?用ID连接2个表.

通过这个视图可查询2表内容，例如姓名，性别，出生日期...我实在没办法了..自己写的老是跳错，oracle真心难

Answer 1

create view view_name as
select * from table1 t1,table2 t2
where t1.id=t2.id

Answer 2

CREATE or REPLACE view view_will as
select * from table1 t1,table2 t2
where t1.id=t2.id

Answer 3

CREATE or REPLACE view view_will as
select * from table1 t1,table2 t2
where t1.id=t2.id

Answer 4

create view