Hi,
I need to create a function that does the following.
I/P is "LONDON,CHICAGO,SANFRANCISCO"
O/P is 'LONDON','CHICAGO','SANFRANCISCO'
This is the function that i require.
The function must be able to run even with a select statement. and
also with user defined parameters... like...
join(assuming this is the name of the function)
select join(select emp_name,emp_address from emp) from dual;
or
select join("ABCD,SAFSAFD,SDFSDFS") from dual;
Please help me to attain the functionality....
A very simplistic solution preferred.
Please mail me the reply at vharicharan@[EMAIL PROTECTED]
....
|
