Re: Set Space clause?

yliu wrote
> what " Set Space 5" does in a SQL*PLUS script?

It sets the number of spaces between each column to 5. Just try:

    set space 1
    select 'First column', 'Second column'     from dual;

    set space 10
    select 'First column', 'Second column'     from dual;

    set colsep '#'
    select 'First column', 'Second column'     from dual;

Arjan. Received on Tue Mar 30 1999 - 16:19:32 CST