Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle SQL creating table as a copy of table

Re: Oracle SQL creating table as a copy of table

From: Paweł <pmg3REMOVETHIS_at_op.pl>
Date: Sun, 17 Apr 2005 21:16:23 +0200
Message-ID: <6hpfrk3scuxw.dlg@www.pmg3.pl>


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

> DA Morgan <damorgan_at_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. Received on Sun Apr 17 2005 - 14:16:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US