Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE STATION (
  CITY VARCHAR(100)
);
INSERT ALL
  INTO STATION (CITY) VALUES  ('City A')
  INTO STATION (CITY) VALUES  ('City CCC')
  INTO STATION (CITY) VALUES ('City BB')
SELECT * FROM dual;
3 rows affected

SELECT CITY, LENGTH(CITY) 
FROM STATION 
ORDER BY LENGTH(CITY) DESC, CITY 
FETCH FIRST ROW ONLY;


CITY
LENGTH(CITY)


City CCC
8


SELECT * 
FROM (
  SELECT CITY, LENGTH(CITY) 
  FROM STATION 
  ORDER BY LENGTH(CITY) DESC, CITY
)x WHERE ROWNUM = 1;


CITY
LENGTH(CITY)


City CCC
8


SELECT CITY, LENGTH(CITY) 
FROM STATION 
WHERE ROWNUM = 1 
ORDER BY LENGTH(CITY) DESC, CITY;


CITY
LENGTH(CITY)


City A
6