Re: too long SQL*plus query ?

[Quoted] Got a specif SQL*Plus error or Oracle error?? That would help?

George wrote:
>
> Hello.
> I need to export a table of a database into a plain text file.
> So far, a simple "select * from tablename;" spooled in a file
> would do the job.
>
> Only that I need each element divided by a comma.
>
> So far, I figured out I could use a statement like:
> select id||','|| name||','|| surname||','|| lastname ||','|| title from tablename;
>
> This works exceptionally well - only: I need all columns of the table in the
> output, that are in total 40, and the statement works only including
> up to the 16th. There is also no syntax problem, since I can take other
> 16 (from the middle or end) and it works also....
> It fails only when I add a number 17.
>
> Do you have any idea how I can get this done ?
>
> Thanks - and be kind to each other :)
>
> George
Received on Wed Jul 25 2001 - 05:22:46 CEST