[에러메세지][Oracle] ORA-00998: must name this expression with a column alias

꿈꾸는개발자maker 2022. 3. 27. 18:40

2022. 3. 27. 18:40

728x90

메세지

ORA-00998: must name this expression with a column alias

원인

컬럼에 별칭 짓겠다고 하고 안만들어서 난 에러

※별칭 생성해야만 할 때 : 서브쿼리 SELECT절 안에 함수가 포함되면 반드시 별칭 지정

728x90

[에러메세지][Oracle] ORA-25154: column part of USING clause cannot have qualifier (0)	2022.04.02
[에러메세지][Oracle] ORA-08002: sequence SEQ_EMPID2.CURRVAL is not yet defined in this session (0)	2022.03.27
[에러메세지][Oracle] ORA-12983: cannot drop all columns in a table 12983. 00000 - "cannot drop all columns in a table" (0)	2022.03.27
[에러메세지][Oracle] ORA-01441: cannot decrease column length because some value is too big (0)	2022.03.27
[에러메세지][Oracle] ORA-01841: (full) year must be between -4713 and +9999, and not be 0 (0)	2022.03.27

힘내보자