On Tue, Jun 27, 2000 at 11:12:59AM -0700, Chuck Hamilton wrote:
>
> I'm not sure what you mean. If you mean you want to append a | to all rows the answer is simple...
>
> select docnum||'|' from ...;
>
> If you mean you want a new column for each row returned there is no way to do it in SQL without first knowing the number of rows being converted into columns. I think something like that would best be handled with a spreadsheet. You could probably do it in Unix too by piping the results of the query through awk and/or sed to build in "insert" or "create table as select... from dual" statement.
The user makes a search and gets a list document numbers as result.
I need to store all document numbers from the query. When the user
gets 100000 hits it is more efficient to store ale document numbers
as one string in one column instead of storing in 100000 rows
in a result table.. thats's the background.
Received on Tue Jun 27 2000 - 13:21:05 CDT
