convert MSSQL Query to Oracle Query

I am a trainee programmer doing programming in delphi. I am getting difficulties in conversion of SQL Query to Oracle The Query is as follows

SQL.Add('declare _at_lastinsp datetime');

      SQL.Add('select _at_lastinsp=max(inspdate) from vwnvnxin where systemkey= :systemkey');

      SQL.Add('select * from vwnvnxin where inspdate=_at_lastinsp and systemkey= :systemkey');

How can I convert the above query to Oracle.

Thanks

Shivas Received on Mon Sep 16 2002 - 15:54:31 CEST