table create vs alter

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Fri, 17 Aug 2001 01:57:32 -0700
Message-ID: <F001.0036E7AC.20010817020035@fatcity.com>

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,

--

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). Received on Fri Aug 17 2001 - 03:57:32 CDT