set colsep ,
in sqlplus
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Tyler Smith Watu" <watuni2000_at_yahoo.co.nz> a écrit dans le message de
news:2f3438a4.0401211158.3a057d6f_at_posting.google.com...
> I will like to be able to seperate the columns based on a comma
>
> For example given .............
> Tyler,,COMP1,prd,main.exe
> Smith,Smith,COMP23,dev.exe
> Watu,,COMP7,prde.exe
> ********************************
>
> I will like to select the first column and the third column seperated
> by ","
> The query should return
>
> Tyler COMP1
> Smith COMP23
> Watu COMP7
>
> Thanks in advance for your assistance
>
> TY
Received on Wed Jan 21 2004 - 14:45:21 CST
