To intercept a field with delimiters

1 View Table Data

Sql> select * from Test1;

ID NAME
---------- ----------------------------------------------------------------
1 Zhengjiang/hangzhou/bingjiang
2 Taizhou/sanmen/xiaoxiong
3 Jiaxing/Haining County/Xu Xiang Zhen

2 View separated data

Select substr (T.name, 1, InStr (T.name, '/')-1),
SUBSTR (T.name,
InStr (T.name, '/') + 1,
InStr (T.name, '/', 1, 2)-InStr (T.name, '/')-1),
SUBSTR (T.name, InStr (T.name, '/', 1, 2) + 1)
From Test1 t

Sql> Select substr (t.name, 1, InStr (T.name, '/')-1),
2 substr (T.name,
3 InStr (T.name, '/') + 1,
4 InStr (T.name, '/', 1, 2)-InStr (T.name, '/')-1),
5 substr (T.name, InStr (T.name, '/', 1, 2) + 1)
6 from Test1 t;

SUBSTR (T.name,1,instr (t.name, ' SUBSTR t.name,instr (t.name, '/') SUBSTR (T.name,instr (T.name, '/')
-------------------------------------------------------------------------------- ------------------------------- ------------------------------------------------- -------------------------------------------------------------- ------------------
Zhengjiang Hangzhou Bingjiang
Taizhou Sanmen Xiaoxiong
Jiaxing Haining County Xu Xiang Zhen

Sql>