ORA-00905: missing keyword,创建视图错误！

2014-01-28

create table EMPLOYEES(EMPLOYEE_ID NUMBER, EMP_NAME VARCHAR2(30), JOB_ID VARCHAR2(20), SALARY NUMBER

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啊！

热点排行

oracle

ORA-00905: missing keyword,创建视图错误！