How to change linesize in command window

[Intexcorp]

Hi,
I am using 6.0.2 and now facing problem in changing linesize in command window. I seems to me that it always set to 80 nomatter how large the value I set. As a result, my output is truncated.
Please advice how to change it.
Thanks
Ricky

 

[Marco Kalter]

What kind of output is truncated? Can you send me an example?

 

[CTzen]

ok, this is what I do

SQL> select '['||rpad('X', 60, 'X')||']' from dual;

'['||RPAD('X',60,'X')||']'
--------------------------------------------------------------
[XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX]

SQL> select '['||rpad('X', 80, 'X')||']' from dual;

'['||RPAD('X',80,'X')||']'
--------------------------------------------------------------------------------
[XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SQL> set linesize 90
SQL> select '['||rpad('X', 80, 'X')||']' from dual;

'['||RPAD('X',80,'X')||']'
--------------------------------------------------------------------------------
[XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SQL> column cmd format a90
SQL> select '['||rpad('X', 80, 'X')||']' cmd from dual;

CMD
------------------------------------------------------------------------------------------
[XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX]

 

[Marco Kalter]

I see. You can (for example) use SET COLWIDTH 90 to fix this.

 

[sxgoodman]

Here is an example in 6.0.2.880 that can't use the above. I really need to be able to set lines 130 or greater in the command window. The plan is truncated. I don't want it wrapped even if I could cause it would be hard to read. The 'set linesize' comnmand returns an error.

explain plan for
SELECT *
FROM b_claim_test.CLAIM C
INNER JOIN b_claim_test.CLAIM_DIAG5 DX USING (CLAIM_ID, PLAN_ID)
where plan_id = 11
/

Explained
select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost | Ps
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 58M| 7215M| | 7134 |
|* 1 | HASH JOIN | | 58M| 7215M| 86M| 7134 |
| 2 | PARTITION HASH ALL | | | | | |
|* 3 | TABLE ACCESS FULL | CLAIM_DIAG5 | 58M| 1398M| | 245 |
| 4 | PARTITION HASH ALL | | | | | |
|* 5 | TABLE ACCESS FULL | CLAIM | 93M| 9262M| | 1408 |
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("C"."CLAIM_ID"="DX"."CLAIM_ID")
3 - filter("DX"."PLAN_ID"=11)
5 - filter("C"."PLAN_ID"=11)
Note: cpu costing is off

20 rows selected

Thanks,

-- Seth

 

[Marco Kalter]

You will need to use the SET COLWIDTH 130 command.

 

[sxgoodman]

Thanks for setting me straight. That worked great. I was getting confused because I thought it was a linesize issue as opposed to a column issue.

-- Seth