SQL select statements

@get_pri=<<ENDOFSQL;

select '<option value="'||lk_code||'">', lk_desc

from oratut.lookup where lk_type='PRI';

ENDOFSQL

@get_sw=<<ENDOFSQL;

select '<option value="'||lk_code||'">', lk_desc

from oratut.lookup where lk_type='SW';

ENDOFSQL