PL/SQL编程—视图

create or replace view test_view
as select
TestA.id,
TestB.idno,
TestB.name,
TestB.sex
from TestB left join TestA on TestB.idno=TestA.id;