There is no limit 1 condition (thats MySQL / PostgresSQL) in Oracle, you need to specify where rownum = 1 .continue reading