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错误，如何解决？

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