Given table: CREATE TABLE testtab (d_col CHAR(4));
Question 1: It appears that there is no "harm" in just appending
directives onto the alter table command even if the order doesn't make
sense. It appears the parser figures it out... For example...
ALTER TABLE testtab ADD COLUMN c_col char(4) FIRST,
ADD COLUMN b_col char(4) FIRST,
ADD COLUMN a_col char(4) FIRST;
...does end up with a_col then b_col then c_col then d_col... but does
it matter and I doing something wrong?
Question 2: Is that any more efficient than doing...
ALTER TABLE testtab ADD COLUMN c_col char(4) FIRST;
ALTER TABLE testtab ADD COLUMN b_col char(4) FIRST;
ALTER TABLE testtab ADD COLUMN a_col char(4) FIRST;
If it's NOT more efficient then I won't bother rewriting this one app
which runs slowly to join them up because it certain is easier to read
and debug with each modification on its own line.
Thanks!
Matt

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.