sql*plus, clr preceded all 1st columns names...

I've been frequently annoyed recently by the output in sqlplus (non-gui version, 8.1.7) of my queries etc. The first column returned always had a prefix of "cls". Couldn't figure it out until I played with the glogin.sql script.

comment out the "column ROWLABEL..." part like so:

...
-- SQL*Plus Global Login startup file.
--

• Add any sqlplus commands here that are to be executed when a user
• starts SQL*Plus on your system
• Used by Trusted Oracle
• column ROWLABEL format A15 <<<----- ...

That solved my problems. That "cls" is no longer there, and my columns align properly now.

Anyways, just thought I'd share that little tidbit, for anyone who is remotely interested.

Cheers,

Bricklen

;-) Received on Wed Apr 03 2002 - 13:19:05 CST