Mike Moxcey 1999

SQL "software" select statement

Several ways to do this in Oracle.
Simplest is using text constants.

Here is one that works:

select '<option value="'||lk_code||'">', lk_desc
from oratut.lookup
where lk_type='SW';


home next