Viewing 4 posts - 1 through 4 (of 4 total)
i am using plsql developer 4.1
October 5, 2020 at 11:08 am
#3792817
hi jhon it is still giving error this is the query
select TOP 1 PREM_ID, CHAR_TYPE_CD, CHAR_VAL, EFFDT, ADHOC_CHAR_VAL
from CI_PREM_CHAR
WHERE CHAR_TYPE_CD = 'UNITS'
AND prem_id = '1589612791'
ORDER BY EFFDT DESC ;
ERROR
ORA-00923: FROM...
January 22, 2020 at 12:26 pm
#3717341
#3717340
sorry attaching the screen shot of the table
January 22, 2020 at 10:42 am
#3717305