Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Couple of oracle questions

Re: Couple of oracle questions

From: Johan <jovo_at_NOSPAMknoware.nl>
Date: Fri, 24 Aug 2007 21:43:26 +0200
Message-ID: <1i3dcyu.lmnipk1nzaevoN%jovo@NOSPAMknoware.nl>


<chunji08_at_gmail.com> wrote:

> On Aug 24, 11:01 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net>
> wrote:
> > Comments embedded.
> > On Aug 24, 12:47 pm, chunj..._at_gmail.com wrote:
> >
> > > Hi there,
> > > I am NEW to the Oracle, and I have two questions here.
> > > 1. Let's say I am going to run a "select ... " sql, is there an easy
> > > way for me to set the format of the output? When I was using
> > > PostgreSQL, I can run a "/x" to have the output in vertical or
> > > horizontal format, is there a similar command in oracle ?
> >
> > No.
> >
> > > 2. For such "select ..." sql, how can I get the column name along with
> > > the output ?
> >
> > Normally headers are enabled, providing the column name or alias you
> > assign to a column value at the top of each 'page' of output:
> >
> > SQL> select table_name from user_tables;
> >
> > TABLE_NAME
> > ------------------------------
> > ....
> >
> > And, normally the pagesize is set to 14, so you get a number of
> > headers output for what would appear to be a 'normal' page of output.
> > Using:
> > set pagesize 60
> > at the SQL> prompt (from SQL*Plus) will provide a more 'pagelike'
> > output.
> >
> > > I was using SQLPLUS on linux box.
> > > Thank you for the tips.
> > > Charlie.
> >
> > David Fitzjarrell
>
> Thank you.
> Charlie,

Maybe the following is off interest to you:

Here you find a SQL*Plus reference:
http://download.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm

Johan

-- 
_____________________________________
Ing. Johan van Oostrum
chaos geordend - www.chaosgeordend.nl
_____________________________________
Received on Fri Aug 24 2007 - 14:43:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US