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;
PL/SQL编程—视图
原文：http://www.cnblogs.com/lingyejun/p/7096785.html
