Insert Oracle column after an existing column

Navigation
0

I need help. I have the USUARIO table, where I have the columns LOGIN , SENHA but I need to include the column called DATACRIACAO , but I would like to know how to insert this column DATACRIACAO after column LOGIN , I'm working with Oracle 11g .

    
asked by anonymous 27.01.2017 / 14:13

1 answer

0

To add the databinding column in the user table 

ALTER TABLE usuario 
ADD (datacriacao date)

However, it is not recommended to change the sequence of columns just as you want, here is explained the reason

    
27.01.2017 / 14:14
Import model class attributes from another app And when overflow does not work?