Re: [SQL] Needs Function

2007-05-03 Thread Bart Degryse
Well, actually it was there last week too :) >>> "Aaron Bono" <[EMAIL PROTECTED]> 2007-05-03 16:14 >>> On 5/3/07, Rodrigo De León <[EMAIL PROTECTED]> wrote: See: http://archives.postgresql.org/pgsql-general/2005-12/msg00080.php Man, where was this last week when I needed it. I will have

Re: [SQL] Needs Function

2007-05-03 Thread Aaron Bono
On 5/3/07, Rodrigo De León <[EMAIL PROTECTED]> wrote: See: http://archives.postgresql.org/pgsql-general/2005-12/msg00080.php Man, where was this last week when I needed it. I will have to keep this for future reference. Thanks! -- ===

Re: [SQL] Needs Function

2007-05-03 Thread Rodrigo De León
On 5/2/07, Penchalaiah P. <[EMAIL PROTECTED]> wrote: I need a user defined function for the following purpose…. If I pass a string with comma ( , ) separated chars/values…. It should be appear in next line… Ex: select get_sep_str ('SK, rp, h, j, 6, 9, kl') from dual; Output : SK rp h j 6

[SQL] Needs Function

2007-05-02 Thread Penchalaiah P.
I need a user defined function for the following purpose If I pass a string with comma ( , ) separated chars/values It should be appear in next line... Ex: select get_sep_str ('SK, rp, h, j, 6, 9, kl') from dual; Output : SK rp h j 6 9 kl (Or) I have one table like thi

[SQL] Needs Function

2007-05-02 Thread Penchalaiah P.
PLEASE GO TO FOLLOWING QUERY AND REVERT TO ME IF ANY QUERIES SELECT * FROM TEMP; DEPTNO EMPNO -- -- 10 B3091,B3092,B3093,B3085 11 3651,6521 12 H3062 1 SELECT DEPTNO,SUBSTR(EMPNO,