[Oracle]ORA-00923: FROM keyword not found where expected

執行下列語句

SELECT *,  ROW_NUMBER() OVER (ORDER BY LOG_DATE ) AS RN FROM TEMP3;

返回如下錯誤

ORA-00923: FROM keyword not found where expected

猜猜看哪裡錯？

用*是不好的，但是不是該告訴我錯哪？

這樣寫用別名的*是OK

SELECT t.*,  ROW_NUMBER() OVER (ORDER BY LOG_DATE ) AS RN FROM TEMP3 t;

或是不用*也可

SELECT ID,  ROW_NUMBER() OVER (ORDER BY LOG_DATE ) AS RN FROM TEMP3;

我覺得很瞎...