Home » SQL & PL/SQL » Client Tools » basic SQL+ setting
basic SQL+ setting [message #310936] Wed, 02 April 2008 21:11 Go to next message
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 #310978 is a reply to message #310936] Thu, 03 April 2008 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what setting do you prefer and why?

The one that allows me to read a line in one shot without moving my eyes or scrolling.

Regards
Michel
Re: basic SQL+ setting [message #311165 is a reply to message #310936] Thu, 03 April 2008 11:03 Go to previous message
Barbara Boehmer
Messages: 8636
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> 

Previous Topic: how to set direction key in SQLPLUS?
Next Topic: /nolog
Goto Forum:
  


Current Time: Fri Dec 09 13:31:18 CST 2016

Total time taken to generate the page: 0.33407 seconds