Does anyone have PL/SQL code to add new field in an Oracle table with specific order?
Posted on 2014-12-29
I need to add fields to tables and I do not want them added to the end of the table order. I know that I can create temp table, add the field, and then repopulate from the temp table. This is tedious.
I would like a procedure that would take in a schema, table_name, new_field_name, new_field_type, and order_number. Then, the new field would be added to the table and the table would maintain constraints/grants/triggers etc.
Does anyone know if this exists already?