oracle建立视图 ORACLE多个表怎么建视图？

ORACLE多个表怎么建视图？Create view view name asselect*从第一个表名、第二个表名、·········································

ORACLE多个表怎么建视图？

Create view view name asselect*从第一个表名、第二个表名、·····················································································。

Oracle多表创建的视图insert的解决方法有哪些？

从EMP eleft join dept d on d.deptno=e.deptno-—EMP deptve是给定给视图的视图名称。第二种方法是从EMP eleft join dept d on d.deptno=e.deptno创建或替换视图EMP deptve asselect e.empno、e.ename、e.job、e.hiredate、e.sal、d.dname、d.locfrom EMP eleft join dept d on d.deptno