Col size [message #430532] |
Tue, 10 November 2009 22:42  |
deep0983
Messages: 28 Registered: April 2009
|
Junior Member |
|
|
Hi
I have written one script file and i want to show all my select data in log file.
so for that i have wrote query like this.
Set Heading on
col aa FOR A30
col bb FOR A30
col MED FOR A30
aa bb MED
-------------- ------------ ---------------------------
########## ########## Comment
########## ########## Comment
########## ########## Document content
the return type for aa and bb is integer.
it should return int value. but for third col it's var char. it's perfectly return the values.
can any body help me to short it out.
|
|
|
|
Re: Col size [message #430535 is a reply to message #430534] |
Tue, 10 November 2009 22:52   |
deep0983
Messages: 28 Registered: April 2009
|
Junior Member |
|
|
hi manu,
i have written the query like this.
ACCEPT LOG_DIR PROMPT 'Please enter the full path to the log files (default C:\Temp): ' DEFAULT C:\Temp
column dcol new_value addedValue noprint
select USER||'_'||(SELECT GLOBAL_NAME FROM GLOBAL_NAME)||to_char(sysdate,'YYYYMMDD_HH24MISS') dcol from dual;
SPOOL &&LOG_DIR\sol_&addedValue..log
set serveroutput on size 1000000 format wrapped
set heading off
Set Verify off
Set autotrace off
SET PAGESIZE 300
SET LINESIZE 500
set feedback off
Set Heading on
col aa FOR A30
col bb FOR A30
col med FOR A30
select query......
set feedback off
|
|
|
|
|
|