If you faces this error, Check out follow things.
- Checks the SELECT portion of COLUMN between SELECT and FROM
Ex)
GENDER AS g,
LAST_VISIT_DT AS l,
FROM table_name
-> you must delete ‘,’ where in front of FROM
GENDER AS g,
LAST_VISIT_DT AS l
FROM table_name
- Check the alias.
Ex1) where you put the '', delete or change that.
Ex2) as the game -> never put the space.
-> as tg
- Syntax check.
Ex) The part that fetches the upper data.
[MSSQL]
SELECT TOP 10*
–> Change
[ORACLE]
'Oracle > Oracle Error' 카테고리의 다른 글
[Oracle] 4. ORA-00933 sql command not properly ended (0) | 2017.11.10 |
---|---|
[Oracle] 2. ORA-01861 literal does not match format string (0) | 2017.10.18 |
[Oracle] 1. ORA-01722 invalid number (0) | 2017.10.18 |