column alignment in sqlplus mode--how?

column alignment in sqlplus mode--how?

[f geisler]

How can I assure columns align in the *SQL* buffer?

When displaying a table in my *SQL* (sql-oracle) buffer, column
alignment is often a problem. The column format is set, and aligns
correctly in a non-emacs window. I presume the problem is related to
tabulation, although a simple replace with spaces did not help.

Thanks in advance for you help.

Re: column alignment in sqlplus mode--how?

[Mathias Dahl]

fgbulk@yahoo.com (f geisler) writes:

> When displaying a table in my *SQL* (sql-oracle) buffer,
> column alignment is often a problem. The column format is
> set, and aligns correctly in a non-emacs window. I presume
> the problem is related to tabulation, although a simple
> replace with spaces did not help.

Can you give an example of how it looks? I use sql-oracle
quite much and have no problems with it. I use a lot of

col my_col format a10 trunc

though...

Re: column alignment in sqlplus mode--how?

[Galen Boyer]

On 21 Jul 2004, fgbulk@yahoo.com wrote:
> How can I assure columns align in the *SQL* buffer?
> 
> When displaying a table in my *SQL* (sql-oracle) buffer, column
> alignment is often a problem. The column format is set, and
> aligns correctly in a non-emacs window. 

The only time I've seen this is on

   select attr,count(*) ..
   group by attr;

> I presume the problem is related to tabulation, although a
> simple replace with spaces did not help.
> 
> Thanks in advance for you help.

Try the sqlplus setting
"set tab off"

Does this change the behaviour?

-- 
Galen Boyer

Re: column alignment in sqlplus mode--how?

[f geisler]

Galen Boyer <galenboyer@hotpop.com> wrote in message news:<uekn4p0kl.fsf@standardandpoors.com>...
> On 21 Jul 2004, fgbulk@yahoo.com wrote:
> > How can I assure columns align in the *SQL* buffer?
> > 
> > When displaying a table in my *SQL* (sql-oracle) buffer, column
> > alignment is often a problem. The column format is set, and
> > aligns correctly in a non-emacs window. 
> 
> The only time I've seen this is on
> 
>    select attr,count(*) ..
>    group by attr;
> 
> > I presume the problem is related to tabulation, although a
> > simple replace with spaces did not help.
> > 
> > Thanks in advance for you help.
> 
> Try the sqlplus setting
> "set tab off"
> 
> Does this change the behaviour?


Yes! Thanks so much.