How to do this in procedures

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

Regards
Ram Received on Fri Jul 01 2005 - 01:06:20 CDT