Re: v6.0 sqlplus 'set' question
From: Ray Chance <rchance_at_netcom.com>
Date: Wed, 8 Sep 1993 14:22:24 GMT
Message-ID: <rchanceCD1H9D.9o4_at_netcom.com>
Date: Wed, 8 Sep 1993 14:22:24 GMT
Message-ID: <rchanceCD1H9D.9o4_at_netcom.com>
Rich Pinder (rpinder_at_hsc.usc.edu) wrote:
: I'm a new user of Oracle. I would like to set the column delimiter to be
: the | symbol. I see the 'set recsepchar' command, but can't find an
: equivilant for column or field seperators - I'm probably looking right past
: it....
Methinks what you want you won't find...you can set the number of spaces to be between columns with 'set space n', but to get the '|' as a column separator, you'll have to select it directly, i.e., "select col_a, '|', col_b"
: Rich Pinder
: USC School of Medicine
: (213) 342-1640
: rpinder_at_usc.edu
: ||||||||||||||||||||||||||||||||||||||||||||||||||
: --
: Rich
Received on Wed Sep 08 1993 - 16:22:24 CEST