Re: Simple Oracle Questions!
From: John Dennis <jdennis_at_netcom.com>
Date: Sat, 4 Jun 1994 03:10:01 GMT
Message-ID: <jdennisCqurGq.5Kz_at_netcom.com>
Date: Sat, 4 Jun 1994 03:10:01 GMT
Message-ID: <jdennisCqurGq.5Kz_at_netcom.com>
Jay Patel (pateljb_at_ucunix.san.uc.edu) wrote:
: Folks,
: I'm learning Oralce (6.0), so please, excuse my simple questions.
: 2) Can I interst a character(i.e., *) in the output of a select??
: I want the output to be
: Name1 * Zip1
: Name2 * Zip2
: Name3 * Zip3
hmm..
how about :
select name || ' * ' || zip from tab1;
standard SQL..
John Dennis Received on Sat Jun 04 1994 - 05:10:01 CEST