Re: SQL Column problem

Try using column aliases. They should solve this problem and save you a BUNCH of typing. It's in the SQLPLUS manual if you need more info.

Column ra_id_ver format a10 heading 'RA ID';

: column rsc.rsc_id||rsc.version format a10 heading 'RA ID';

select rsc.rsc_id||'.'||rsc.version ra_id_ver, rsc.component_long_name

: select rsc.rsc_id||'.'||rsc.version, rsc.component_long_name

--
Mark McGregor     mmcgreg_at_uswnvg.com

** I try to speak only for myself, so that my foot doesn't end up in **
** someone else's mouth                                              **