RE: table create vs alter

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 17 Aug 2001 06:01:29 -0700
Message-ID: <F001.0036EB37.20010817052550@fatcity.com>

g,

why not try it????

the answer is - no difference.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Friday, August 17, 2001 6:01 AM
To: Multiple recipients of list ORACLE-L

Hi,

Does anyone know if the end result of these two statements is actually any different?

CREATE TABLE mytable (

        mycol1 NUMBER,
        mycol2 VARCHAR2(40),
        mycol3 VARCHAR2(30));

and

CREATE TABLE mytable (

        mycol1 NUMBER);
ALTER TABLE mytable ADD (mycol2 VARCHAR2(40)); ALTER TABLE mytable ADD (mycol3 VARCHAR2(30));

Since no data is loaded, will Oracle have create the table in exactly the same way at the end of both two methods?

Thanks,

g

--

Guy Hammond
AVT Technologies
12-16 Westland Place
London N1 7LP UK

Email: guy.hammond_at_avt.co.uk
Office: +44 (0) 207 454 1224
Mobile: +44 (0) 7966 164687

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 17 2001 - 08:01:29 CDT