ORACLE多個表怎么建視圖？Create view view name asselect*從第一個表名、第二個表名、·········································

ORACLE多個表怎么建視圖？

Create view view name asselect*從第一個表名、第二個表名、·····················································································。

Oracle多表創(chuàng)建的視圖insert的解決方法有哪些？

從EMP eleft join dept d on d.deptno=e.deptno-—EMP deptve是給定給視圖的視圖名稱。第二種方法是從EMP eleft join dept d on d.deptno=e.deptno創(chuàng)建或替換視圖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