| basic SQL+ setting [message #310936] |
Wed, 02 April 2008 21:11  |
horax
Messages: 34
Registered: March 2008
|
Member |
|
|
Ok people, what's going on here? I usually set my linelength to 300, and my pagesize to 48 so I can see just about everything I need.
However, for some reason, when I do a desc table, it really stretches it out so you can't see it all, but if you do a select * from table it puts it really tight.
I guess my question is this: what setting do you prefer and why?
|
|
|
|
|
|
| Re: basic SQL+ setting [message #311165 is a reply to message #310936] |
Thu, 03 April 2008 11:03  |
 |
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
The SQL*Plus DESCRIBE command or DESC command automatically spreads the columns out to fit the linesize, as demonstrated below. Some things are limited to a maximum linesize of 80, at least without adding scrolling. A lot of things require at least linesize 100, like some formatted explain plan outputs. I try to fit things within 80 characters when I can and either increase the linesize and scroll or wrap the columns onto multiple lines when I can't.
SCOTT@orcl_11g> set linesize 40
SCOTT@orcl_11g> desc dept
Name Null? Type
----------------- -------- ------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
SCOTT@orcl_11g> set linesize 50
SCOTT@orcl_11g> desc dept
Name Null? Type
----------------------- -------- ----------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
SCOTT@orcl_11g> set linesize 60
SCOTT@orcl_11g> desc dept
Name Null? Type
----------------------------- -------- --------------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
SCOTT@orcl_11g> set linesize 70
SCOTT@orcl_11g> desc dept
Name Null? Type
----------------------------------- -------- ------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
SCOTT@orcl_11g> set linesize 80
SCOTT@orcl_11g> desc dept
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
SCOTT@orcl_11g>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
