Re: too long SQL*plus query ?

Well, the "2" I get is the line number of the statement; SQL*plus cuts my command somewhere in the middle and ignores the last half. Because of that, it shows the 2 two indicate the beginning of the second command line.

The same happens, if I let SQL*plus read the command from a file or if I "distribute" it in several lines...

However, as I have figured out in the meanwhile, if I take only five elements of my 40, and truncate them using a comma [so it looks like this; key is the comma at each lines end:

select usrid||'~'|| logname||'~'|| name||'~'|| lastname ||'~'|| title||'~',
company||'~'|| postalcode ||'~'|| street||'~'|| streetnumber||'~'|| address ||'~', 
address2||'~'|| city||'~'|| phone ||'~'|| mobile||'~'|| fax||'~',

Now I know that this doesn't LOOK nice, but as far as it works, I am completely happy ;)

However, if you have an idea to make it more comfartable, it would be welcome...

Thanks for your help and input !
George Received on Thu Jul 26 2001 - 15:27:45 CEST