Re: Column seperator in Sql/Plus

Have you looked at the DBMS_UTILITY.TABLE_TO_COMMA stored procedure? Or, you could write a simple SQL statement as follows:

SELECT column1||','||column3 FROM my_table;

HTH,
Brian

Tyler Smith Watu wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"