| sqlplus- column width printing [message #234568] |
Wed, 02 May 2007 09:39  |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
here is my script.
--TEST CASE : R1-1
set linesize 200
SPOOL qur_log.TXT
select a.item_sid, irm, item_code, sched_process_flag, item_review_bypass_flag
from work_item_postload a, work_productive_item b
where sched_process_flag = 'N' and
a.item_sid = b.item_sid and
b.item_review_bypass_flag = 'Y';
SPOOL OFF;
ITEM_SID IRM ITEM_CODE S I
---------- ------ -------------- - -
100362364 200606 4926--AB025A06 N Y
100362364 200609 4926--AB025A06 N Y
100362364 200605 4926--AB025A06 N Y
100362364 200607 4926--AB025A06 N Y
100362364 200608 4926--AB025A06 N Y
It spools the results to a text file.My question is how do print the column name in full instead of just one character ('S' for sched_process_flag) in my spooled file.
|
|
|
|
|
|
| Re: sqlplus- column width printing [message #234641 is a reply to message #234570] |
Wed, 02 May 2007 13:55  |
jinga
Messages: 116
Registered: January 2003
|
Senior Member |
|
|
Thank you... it worked.
Another question.
I am redirecting the out put in HTML format.
--TEST CASE : R1-1
set linesize 200
set markup HTML on
set feedback off
SPOOL C:\R1_1_AFTER_LOG.html
set heading off
SELECT 'TEST CASE: R1_1 ' FROM DUAL;
SELECT 'STATE : DATA BEFORE ' FROM DUAL;
set heading on
column sched_process_flag format a15
column item_review_bypass_flag format a15
select a.item_sid, irm, item_code, sched_process_flag, b.item_review_bypass_flag, update_datetime
from work_item_postload a,productive_item b, work_productive_item c
where sched_process_flag = 'N' and
a.item_sid = b.item_sid and
a.item_sid = c.item_sid and
b.item_review_bypass_flag = 'Y'
and a.item_sid = 100362364;
SPOOL OFF;
set heading off
set markup HTML off
now when i execute, i see the HTML commands displayed in the screen. Is there a way to not display it on the screen.
Ananthi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
