Re: How to do this in procedures

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 30 Jun 2005 23:15:50 -0700
Message-ID: <1120198550.768663.225840@f14g2000cwb.googlegroups.com>

ramprakash.a_at_gmail.com wrote:
> Hi
>
> while in procedures, I want some columns in a table seperated by "|"
> symbol in a variable
>
> take for example emp table
>
> i need ename,job,sal,deptno from emp table in a single string like
> 'SMITH|CLERK|800|20'
> here the table and column changes often. so i need to generalise this.
> this is not only for emp table.
>
> and if i have the string similar to this how can i insert or update
> into the table

Use Oracle' concatenation operator:

• Replace with column names as desired... SELECT 'Foo' || '|' || 'Bar' || '|' || 'Baz' AS "Concatenated String" FROM DUAL;

Cheers,
Chris Val Received on Fri Jul 01 2005 - 01:15:50 CDT