CREATE VIEW C_R AS
SELECT LICENSEPLATE, CARNAME, CARMODEL, CARCOM, CONDITION, FUEL, RENT, PASSENGER, DISTANCE
FROM CAR_RELATIONS CR, CAR CA, CARMODEL CM, CARCOM CO, PASSENGER PG, RENT RT, FUEL FL, CONDITION CN, DISTANCE DE
WHERE CM.CARMOCODE = CA.CARMOCODE, CO.CARCOMCODE = CA.CARCOMCODE, CA.CARCODE = CR.CARCODE, DE.DTCODE = CR.DTCODE, CN.CDCODE = CR.CDCODE, FL.FCODE = CR.FCODE, RT.RCODE = CR.RCODE, PG.PASSENGERCODE = CR.PASSENGERCODE;
오류 보고 -
SQL 오류: ORA-00933: SQL 명령어가 올바르게 종료되지 않았습니다
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
문법이나,새미콜론에서 오류가 나오는데 이유를 몰라 질문드립니다.