뷰를 생성하려 합니다

...

16 FROM

17 sa.USER_CREATE_INSTANCE PROJ_LEADER_NAME=

18 (SELECT PROJECT_INSTANCE.OBJ_ID AS PROJ_ID, MAX(USER_CREATE_INSTANCE.OBJ_ID) AS C_ID

19 FROM sa.CLASS_REL_INSTANCE = sa.PROJECT_INSTANCE

20 ON sa.CLASS_REL_INSTANCE.OBJ_ID_PARENT := sa.PROJECT_INSTANCE.OBJ_ID =

21 sa.USER_CREATE_INSTANCE

22 ON sa.CLASS_REL_INSTANCE.OBJ_ID := sa.USER_CREATE_INSTANCE.OBJ_ID

23 GROUP By PROJECT_INSTANCE.OBJ_ID, USER_CREATE_INSTANCE.CREATE_REASON

24 HAVING (USER_CREATE_INSTANCE.CREATE_REASON := 'PROJECT LEADER'))PROJ_LEADER_ID ON

25 PROJ_LEADER_NAME.OBJ_ID := PROJ_LEADER_ID.C_ID =

26 SYSTEM_USER_INSTANCE LEADER_NAME_INSTANCE ON

27 LEADER_NAME_INSTANCE.OBJ_ID :=

28 PROJ_LEADER_NAME.USER_ID = DATE_INSTANCE(+) =

29 CLASS_REL_INSTANCE ON

30 DATE_INSTANCE.OBJ_ID :=

31 CLASS_REL_INSTANCE.OBJ_ID =

32 PROJECT_INSTANCE(+) ON

33 CLASS_REL_INSTANCE.OBJ_ID_PARENT := PROJECT_INSTANCE.OBJ_ID(+)=

34 STD_PROJ_STAGE ON

35 PROJECT_INSTANCE.PROJ_STAGE := STD_PROJ_STAGE.PROJ_STAGE_ID(+)=

36 STD_PROJ_TYPE ON

37 PROJECT_INSTANCE.PROJ_TYPE := STD_PROJ_TYPE.PROJ_TYPE_ID ON

38 PROJ_LEADER_ID.PROJ_ID := PROJECT_INSTANCE.OBJ_ID

39 ;

를 했더니

sa.USER_CREATE_INSTANCE PROJ_LEADER_NAME=

*

17행에 오류:

ORA-00933: SQL 명령어가 올바르게 종료되지 않았습니다

랍니다

해결 방법좀 알려주시면 갑사하겠읍니다