unfortunately , I work at oracle .
instead of TOP , oracle use "where rownum" condition.
If I use
SELECT a.il_kod
FROM m_m_adres a
WHERE a.hesap_no = p_hesap_no
AND a.adres_kod LIKE v_adres_kod_like
AND a.adres_ulke_kod = 169
AND a.il_kod IS NOT NULL
where rownum <= 1 ORDER BY a.tarih,a.adres_kod
this sql execute "where condition" firstly and then "order by" , and this is not my need .