Re: sql syntax

by "Srinivasan Ramakrishnan" <srinivar(at)md3.vsnl.net.in>

Date:	Tue, 12 Dec 2000 16:51:06 +0530
To:	"Franklin, Douglass" <Douglass.Franklin(at)ssa.gov>, <aka_susanb(at)yahoo.com>
Cc:	<hwg-languages(at)hwg.org>
References:	ssa
	todo: View Thread, Original

CREATE table newtable (compositecolumn varchar2);

INSERT into newtable values 
(SELECT col1 || "," || col2 || "," || col3 from oldtable);


or something like that. My SQL is very rusty....

-Srini

----- Original Message ----- 
From: Franklin, Douglass <Douglass.Franklin(at)ssa.gov>
To: <aka_susanb(at)yahoo.com>
Cc: <hwg-languages(at)hwg.org>
Sent: Tuesday, December 12, 2000 1:11 AM
Subject: RE: sql syntax


: Is that like MS Access' action query?
: 
: -----Original Message-----
: From: Susan Bishop [mailto:aka_susanb(at)yahoo.com]
: Sent: Monday, December 11, 2000 1:25 PM
: To: hwg-languages(at)hwg.org
: Subject: sql syntax
: 
: 
: I am trying to figure out the correct way to update a
: column based on another columns.
: 
: I nned to move the values from 3 columns into one
: column.  I.e. 
: 
: column 1 = college
: column 2 = child
: column 3 = <null> (or a value)
: 
: into one column
: 
: column a = college, child ...
: 
: 
: Any ideas ?
: 
: 
: __________________________________________________
: Do You Yahoo!?
: Yahoo! Shopping - Thousands of Stores. Millions of Products.
: http://shopping.yahoo.com/
:

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA