ORA-00905: missing keyword,创建视图异常

ORA-00905: missing keyword,创建视图错误！
点击右边红色标题查看本文完整版：ORA-00905: missing keyword,创建视图错误！

create table EMPLOYEES(EMPLOYEE_ID NUMBER, EMP_NAME VARCHAR2(30), JOB_ID VARCHAR2(20), SALARY NUMBER ,dept_id number);
create table DEPARTMENTS(DEPARTMENT_ID NUMBER, DEPT_NAME VARCHAR2(30));
create view v_emp_dem? select e.*,d.* from EMPLOYEES e join DEPARTMENTS d on e.dept_id=d.DEPARTMENT_ID

报ORA-00905: missing keyword错误，如何解决？

------解决方法--------------------
?

探讨
create table EMPLOYEES(EMPLOYEE_ID NUMBER, EMP_NAME VARCHAR2(30), JOB_ID VARCHAR2(20), SALARY NUMBER ,dept_id number);
create table DEPARTMENTS(DEPARTMENT_ID NUMBER, DEPT_NAME VARCHAR2(30));
create view v_emp_dem as? select e.*,d.* from EMPLOYEES e join DEPARTMENTS d on e.dept_id=d.DEPARTMENT_ID;

少些了一个AS啊！
　　　　

查看更多 下一篇