Table to Lob

[Anonymous]

Hi Michael,

I have used your program LOB2TABLE and it works like a charm.

Do you have a solution to do the reverse i.e. Copy data from TABLE2LOB ?

http://stackoverflow.com/questions/37152097/copying-table-content-to-clob-variable

Regards,
Alwyn D'Souza

[Michael]

Hi Alwyn,

I've implemented a new package cursor2lob that does the reverse.
I'll release it in the next days... so stay tuned.

Regards,
Michael

[Michael]

It's there... Cursor2LOB at http://cursor2lob.sourceforge.net

[Michael]

Hi Alwyn,

it's nice to hear that LOB2Table works well for you.
I have one question: How many columns and rows do you normally query with LOB2Table and how's the performance for you (i.e. row per second)? (High performance is a top feature of LOB2Table.)

Currently I do not have a routine a la TABLE2LOB but that would be a good idea.

I think I could extend LOB2Table with a function that gets a Ref Cursor (and other parameters) and then returns the generated CLOB.
It could work like this:

select  d.deptno, d.dname,
        lob2table.cursor2clob(
          cursor(select empno, ename, sal
                 from   emp e
                 where  e.deptno = d.deptno),
          ',', chr(10)
        ) emps_as_clob
from    dept d

Is this what you have in mind?

Regards,
Michael

[Anonymous]

Hi Michael,

If one of column of my table is CLOB, can this tool still work?

Thanks,

JZ

[Michael]

Hi JZ,

I guess you are asking abou the capabilities of the cursor2lob package?

Well, I seperated this functionality out of lob2table into a new package called cursor2lob.
There is also a specific Sourceforge project for this:
https://sourceforge.net/projects/cursor2lob/

And there you find for example a function that gets a cursor as parameter and return the result as a CLOB.
Consider:

select cursor2lob.to_clob(
         cursor(select id, my_clob_column
                from   my_clob_table),
                chr(10), ',', '"') csv
from   dual

And, yes, the routines in cursor2lob are able to handle even big (>32 KByte) CLOBs.

HTH,
Michael