----------------------------------------------------
Now we decide to include a middleInitial column
We have two choices.
1) We can alter the table to add a middle initial column, and then we can create a view that changes the order of the middleInitial and lastName column. We can then use the view for everything. However, that is not a great solution.
2) We can create a temporary copy of the user table, drop the user table, create the new user table, and then copy over the old data.
----------------------------------------------------
Example:

Yes, as demonstrated below. It does something similar to the previous demonstration of creating an interim table, copying the data, creating a table with the new structure, copying the data, and dropping the interim table. This is a minimal demonstration. Dbms_redefinition has many more features.

However, this thread has nothing to do with Oracle objects, so it does not belong in the objects forum. Perhaps there is someone with moderator privileges who can move it to an appropriate forum.

798637 wrote:
ALTER TABLE table_name
ADD column_name column-definition [ FIRST | AFTER col_name ]
this is the command for add column(in table) in required position

i think it is for mysql but it is all so work for sql just check it once.

That is not valid syntax for Oracle. The SQL used in mysql and the SQL used in Oracle are very different. You can easily tell that it is not valid syntax by either attempting to run it on an Oracle database or checking the online documentation for the syntax for ALTER TABLE.

Also, this thread has nothing to do with Oracle objects, so it is in the wrong forum. If there is somebody with moderator privileges, then please move it to an appropriate forum.