Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-08!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: alter table: add and modify in same statement Date: Thu, 11 Nov 2004 20:33:27 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1100233930.112786@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 16 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:114207 fareeda wrote: > Is it possible to add new columns and modify existing columns in the > same ALTER TABLE statement? > > Regards > Fareeda Did you try it? Did you read the documentation? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)