Hello all,

I've got > 8000 rows in an Oracle table. I'm looking to save the grid
data into some format that will make it easy to parse the fields for
an application that I'm building in TCL/TK.

I'm using TOAD 8.0.0.47. I had trouble saving the entire table into
EXCEL. I have CLOB objects.

What do you recommend in terms of output (XCEL, XML, HTML flat file)
for such a table?

I also need to parse it easily in TCL and create an application that
loads the data and runs it.

The tables are storing scripts.

Thank you!

On Feb 23, 1:00*pm, lora <anjela_... (AT) yahoo (DOT) com> wrote:
You want to:
extract the data (via TOAD) into a file
Parse the file in TCL in order to
load the data to where?? and execute what?

I haven't used TOAD long enough to know how it deals with CLOBs.
Personally I would avoid XCEL format and target the flat file (CSV or
fixed? only one CLOB field??) And it has been a long time since I
touched TCL. I don't recall it being a good parsing language.

So I think my question is really: what is your functional goal? Skip
the tool specific question and tell us what you are trying to achieve.
Ed