If you insist, there are couple of ways :
1. Rename this table to shipping_old
2. Create a view called as shipping with whatever order of columns you want.
2. Create new table as :
create table shipping as select <columns_in_proper_order> from shipping_old;
Hope this helps !!
Originally posted by MaxPlus
I know how to add a new field but my trouble is, how would I put in between 2 other existing fields. Currently my shipping table is
SHIPID, NOT NULL, NUMBER(5)
INVID, NOT NULL, NUMBER(5)
DATE_EXPECTED, NOT NULL, DATE
I want to add a field called quantity_expected and place it in between date_expected and date_recieved. So far I'm stuck the following
ALTER TABLE shipping
ADD (quantity_expected NUMBER(5) CONSTRAINT shipping_quantity_expected_nn NOT NULL);