Column seperator in Sql/Plus

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 - 13:58:23 CST