SQL*Plus problem on COLUMN HEADING
From: Pino Venturella <pino_v_at_hotmail.com>
Date: Wed, 27 May 1998 16:23:17 +0200
Message-ID: <356C21D5.AF55F66F_at_hotmail.com>
Hi All,
[Quoted] [Quoted] I have 2 tables with 2 columns with the same name. I'd like to use SQL*Plus to get a 'nice output' so I wrote a file called nametest.sql where I put
Date: Wed, 27 May 1998 16:23:17 +0200
Message-ID: <356C21D5.AF55F66F_at_hotmail.com>
Hi All,
[Quoted] [Quoted] I have 2 tables with 2 columns with the same name. I'd like to use SQL*Plus to get a 'nice output' so I wrote a file called nametest.sql where I put
COLUMN NAME HEADING WrongHead
COLUMN TABPREFIX.TABNAME1.NAME HEADING Name1 COLUMN TABPREFIX.TABNAME2.NAME HEADING Name2 select TABPREFIX.TABNAME1.NAME, TABPREFIX.TABNAME2.NAME fromTABPREFIX.TABNAME1, TABPREFIX.TABNAME2; Then at SQL> prompt I write _at_nametest and I'd like to see 2 columns with headers Name1 and Name2 but I see that for both columns the header is WrongHead.
Is there any way to solve my problem? Am I doing something wrong? Pls if this is not the rigth newsgroup point me to the rigth one.
Thanks in advance, Pino Received on Wed May 27 1998 - 16:23:17 CEST