Printing longest and shortest name in oracle sql

Printing longest and shortest name from oracle sql:

1 2 3 4 5

select min(city),length(city) from station where length(city) <= all(select length(city) from station) group by length(city); select max(city),length(city) from station where length(city) >= all(select length(city) from station) group by length(city);