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: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 17 Apr 2005 12:38:02 -0700
Message-ID: <1113766456.560085@yasure>


Paul wrote:
>
> 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...

Zero advantage to using CHAR so why deal with it at all?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Apr 17 2005 - 14:38:02 CDT

Original text of this message

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