Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Not sure how to write this in sql
We have a function that loops through a table and grabs all rows
associated with a particular id and builds a string consisting of a
comma delimited, concatenate string of 1-3 rows of a column associated
with that id.
the function returns the string and that string is used to populate a column in another table.
i believe this is possible in a single update statement but i can't figure out how to right it. (as it is, it takes over an hour)
so:
table a
should populate table b like
table b
table a can have 0,1,2, or 3 rows associated with each id.
help?
ps. I have lex's book on order so hopefully my sql skills will continue to grow.
tia
chris
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 12 2005 - 15:53:04 CST
![]() |
![]() |