Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 08 Aug 2006 10:51:19 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: why cant i do this?? any clues on how i should go about References: <1155055350.622603.308140@h48g2000cwc.googlegroups.com> <3bhhd2loel27iuus871srkf2rp3jv61pc7@4ax.com> <1155058143.135170.231620@i3g2000cwc.googlegroups.com> <1155058239.248271.138930@m73g2000cwd.googlegroups.com> In-Reply-To: <1155058239.248271.138930@m73g2000cwd.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Message-ID: <1155059479.463611@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 25 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:129144 Vinay Bhushan wrote: > EXECUTE IMMIDIATE 'ALTER TABLE T ADD (ABCD VARCHAR2(50))'; > > I think there can be no of other ways if any one could point out the > best practice and also explain us why we cant do a Alter table directly > that would be help full; > > SQLserver is is much help full we can put a exists clause and work with > it but this is not true with oracle if exists (Select col_name from > user_tab_columns) then dosnt seem to work does any one kow how to use > this. > > if so that would be of gr8 help some one making a point of best > practice for alter tables. > > Reply Reply with quote » Best practice is to NEVER alter tables using PL/SQL. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org