Home » SQL & PL/SQL » Client Tools » sqlplus- column width printing
sqlplus- column width printing [message #234568] Wed, 02 May 2007 09:39 Go to next message
jinga
Messages: 115
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 #234570 is a reply to message #234568] Wed, 02 May 2007 09:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
column <your column name> format a<length of column name>

For instance,
column item_review_bypass_flag format a22

Regards
Michel
Re: sqlplus- column width printing [message #234641 is a reply to message #234570] Wed, 02 May 2007 13:55 Go to previous messageGo to next message
jinga
Messages: 115
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
Re: sqlplus- column width printing [message #234660 is a reply to message #234641] Wed, 02 May 2007 14:57 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set termout off

Regards
Michel
Previous Topic: TOAD 7.5
Next Topic: Toads Script Runner
Goto Forum:
  


Current Time: Fri Dec 02 23:22:01 CST 2016

Total time taken to generate the page: 0.08383 seconds