How we enter a new column in middle of our old columns?

I want to add a new column in our table and i already have 4 column in table i want that my column should be added at 3rd position not in last position ..

Interview Candidate
Nov 25th, 2014
3
6094

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

S. Venmathi

Jan 5th, 2015
If we are a Admin there is some possible. As my thought, it is not possible. but we can change the order of the column when we show the table. Example, consider your your fourth column is last_name, we can shown at 2nd column. example bellow
Code
SELECT ID, LAST_NAME, SALARY, DEPT_ID FROM EMPLOYEES;