How to append measurement units in Select Statement in SQL Query within the output

Question

I'm using Oracle's SQL Developer.

For example, I've table City with two columns - place and speed_limit. Column speed_limit has datatype number(3) and I want query with select statement with return column speed_limit with units (mph) in the output in column speed_limit.

What I should add to the query?

SELECT speed_limit
FROM city;

to have output like this:

speed_limit 
-----------
    20 mph
    40 mph
   100 mph

instead of:

speed_limit 
-----------
    20
    40
   100

Don't. This involves turning numeric data into strings, which obfuscates it's natural meaning (hard to manipulate after you've done it) and is obviously purely for display purposes. Presentation transformations should happen in the application / reporting environment and not in the database. Presentation Layer != Database Layer. — MatBailie

Mudassir Hasan Mudassir Hasan · Accepted Answer · 2014-04-28T13:04:14

1

votes

SELECT TO_CHAR(speed_limit) || ' mph'
FROM city

How to append measurement units in Select Statement in SQL Query within the output

1 Answers