Use the CREATE VIEW statement to create a view.
使ç¨create view å½ä»¤æ¥å建è§å¾
SQL> 1 CREATE VIEW emp_sal_comm AS
2 SELECT employee_id, salary,
3 salary * NVL(commission_pct,0) commission
4 FROM employees;
å
¶ä¸ emp_sal_comm æ¯è§å¾å
employees æ¯è§å¾æ°æ®æ¥æºï¼è¡¨åï¼
温馨提示:答案为网友推荐,仅供参考