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