Hil All,

I have a table , count is about 200M. It has a column which contains data separated by '~'. I want to parse it.

e.g:

```
Column1
A~B~C~D~E~F

Result :
Column_new1
A~C~E

```

I just want to skip 2,4,6,n th. words. I don't want plsql. I need sql query. And table is very big,I also need performance.

I use substr,instr functions and I can parse. But it runs really slowly..

Thanks for help.