ALTER TABLE requires extra parentheses for Oracle?

From: Dylan Nicholson <wizofaus_at_hotmail.com>
Date: 5 May 2004 18:26:57 -0700
Message-ID: <7d428a77.0405051726.10d5e1b2@posting.google.com>

Seems that Oracle 9.2 (using MS ODBC driver) requires extra parentheses when adding multiple columns to a table:

ALTER TABLE MyTable ADD (MyColumn1 VARCHAR(255), MyColumn2 VARCHAR(255)) vs

ALTER TABLE MyTable ADD MyColumn1 VARCHAR(255), MyColumn2 VARCHAR(255)

The former simply doesn't work with MS Access or SQL server. I'm wondering what the SQL standard is, and whether there is a way (other than adding columns one at a time, which is surely inefficient for a table with existing data) of writing the statement to work with all 3 types of database.

TIA Dylan Received on Wed May 05 2004 - 20:26:57 CDT