Re: Would be really nice if...

bdbafh_at_gmail.com wrote:
> in sqlplus, there is a setting called "noprint"
>
> sql> col unit_no noprint
>
> the data will still be fetched and available for calculations, but will
> not be displayed.
>
> hth.
>
> -bdbafh
>

But it doesn't work with blobs:

baer_at_DEMO10G>create table t2 (id int, body blob);

Table created.

baer_at_DEMO10G>select * from t2;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus baer_at_DEMO10G>col body noprint
baer_at_DEMO10G>select * from t2;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus baer_at_DEMO10G>

I can see Haximus' point, especially since I once came across a DBMS (can't remember the name) that implemented it's own query language - which actually had this feature.

But many of his later remarks (especially about PL/SQL being a dinosaur and him using java) let me rather not support him - I'm getting fed up with this 'oh so clever java' types that will never learn to use a database properly.

But suppressing of the odd blob column in sql*plus without clever scripting or vi tricks I'd quite like.

Cheers,

Holger Received on Fri Feb 25 2005 - 05:11:09 CST