Home » RDBMS Server » Server Administration » report heading
report heading [message #373288] Tue, 10 April 2001 04:15 Go to next message
Paul Azu
Messages: 1
Registered: April 2001
Junior Member
I'm trying to generate a pipe delimited report with
a heading that looks like this :

ENAME|EMPNO|SAL|HIREDATE|COMM
Can anyone please help.
PS. I've got the actual columns seperated by '|' but not the heading.

Report message to a moderator

Re: report heading [message #373289 is a reply to message #373288] Tue, 10 April 2001 04:56 Go to previous messageGo to next message
Iftikhar Ahmad Lodhi
Messages: 4
Registered: April 2001
Junior Member
use qoutes

Report message to a moderator

Re: report heading [message #373290 is a reply to message #373288] Tue, 10 April 2001 05:14 Go to previous messageGo to next message
Iftikhar Ahmad Lodhi
Messages: 4
Registered: April 2001
Junior Member
make a script file in which before query place a SQL*PLUS command "TTITLE" use qoutes to display pipes in heading.you can see help on TTITLE from help menu of SQL*PLUS.

Report message to a moderator

Re: report heading [message #373293 is a reply to message #373288] Tue, 10 April 2001 09:38 Go to previous message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
Use
select 'ENAME'||chr(24)||'EMPNO'||chr(24)||'SAL'||chr(24)||'HIREDATE'||chr(24)||'COMM'
from dual
to get this
ENAME|EMPNO|SAL|HIREDATE|COMM

Report message to a moderator

Previous Topic: Inssert into View
Next Topic: help me
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 16:07:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.