SLTechnology News&Howtos › Database ›

Oracle divides Shandong Province / Jinan City / High-tech Zone into three columns to display.

Shulou Source: shulou.com Published: 2022-06-01 11:31:14 10月06日 Update

SELECT carfullname, REGEXP_SUBSTR (pb_area.carfullname,'[^ /] +', 1, 1) province

REGEXP_SUBSTR (pb_area.carfullname,'[^ /] +', 1, 2) city

REGEXP_SUBSTR (pb_area.carfullname,'[^ /] +', 1, 3) area

FROM pb_area

The effect is

Attachment: http://down.51cto.com/data/2368053