Re: SQL Plus

There are two ways. You can create a LOGIN.SQL file with all of your custom commands in it. When you start SQL*Plus from the directory that contains the LOGIN.SQL file, then this file will be executed right away before control is given to you. Alternatively, there is a GLOGIN.SQL file which is in the sqlplus/admin directory. This will be executed whenever ANYONE starts SQL*Plus

HTH,
Brian

Jill wrote:
>
> Is there anyway to do this globally? We have a table with about 40 or 50
> columns, and I just want to select * from it.
>
> Neilc wrote in message <7qje9j$bk8$1_at_pheidippides.axion.bt.co.uk>...
> >In sqlplus, before you do the select, use
> >
> >column customer_no format 99999999999 if customer_no is number
> >or
> >column customer_no format a11 if customer_no is
> >varchar2
> >select customer_no from table
> >
> >
> >Cheers
> >
> >Jill wrote in message <7qjddm$i99$2_at_bgtnsc02.worldnet.att.net>...
> >>
> >>SQL PLus
> >>
> >>Does anyone know how to widen the the description in the column heading to
> >>display the entire description, and not truncated to the length of the
> >>actual data, e.g.
> >--snip
> >>Thanks for any help
> >
> >
> >
Received on Wed Sep 01 1999 - 16:11:03 CDT