i am using plsql developer 4.1

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...

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...

sorry attaching the screen shot of the table