Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!freenix!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!2001:1a50:0:1::9.MISMATCH!news.rh-tec.net!news.tu-darmstadt.de!tsicnews.teliasonera.com!newsfeed.pionier.net.pl!newsfeed.silweb.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!not-for-mail
From: =?iso-8859-2?Q?Pawe=B3?= <pmg3REMOVETHIS@op.pl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle SQL creating table as a copy of table
Date: Sun, 17 Apr 2005 21:16:23 +0200
Organization: news.onet.pl
Lines: 14
Sender: pmg3@op.pl@194-pra-4.acn.waw.pl
Message-ID: <6hpfrk3scuxw.dlg@www.pmg3.pl>
References: <rrhvan1bz8h8$.dlg@www.pmg3.pl> <1113760268.294244@yasure> <jja561d7i27dgiun6ov7pljojp8j6de4ob@4ax.com>
Reply-To: pmg3REMOVETHIS@op.pl
NNTP-Posting-Host: 194-pra-4.acn.waw.pl
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-2"
Content-Transfer-Encoding: 8bit
X-Trace: news.onet.pl 1113765377 24654 82.210.131.194 (17 Apr 2005 19:16:17 GMT)
X-Complaints-To: abuse@onet.pl
NNTP-Posting-Date: 17 Apr 2005 19:16:17 GMT
User-Agent: 40tude_Dialog/2.0.14.1pl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:240614

Dnia Sun, 17 Apr 2005 19:28:10 +0100, Paul napisał(a):

> DA Morgan <damorgan@x.washington.edu> wrote:
> 
>>ALTER TABLE employees
>>ADD (contractor_flag VARCHAR2(1));
> 
> 
> And why not CHAR(1)? I thought there was a (minimal) overhead with
> VARCHAR2(x), so what's the point in imposing it for a field that you
> know will always be one and only one character? 
> Paul...
Employees and Contractors were only examples, just to picture the idea. :-)
Thanks for your help.