question

nvhungss asked Jun 13, '18

Set result of select query to variable in sql plus

I have a select query in sqlplus

select trim(status) from AML.amletl_load_status where mov_date in(select max(mov_date) mov_date from AML.amletl_load_status);

Then i want to set result return as variable A I use but it seem not work:

getStatusETL
(){select trim(status)from AML.amletl_load_status where mov_date in(select max(mov_date) mov_date from AML.amletl_load_status);!}

sql windows-server-2008-r2 database-objects

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.