add a new column into a database

i'm using a matlab tutorial database i have tried to add new column to salesvolume table by using this code

a=exec(conn,'ALTER TABLE salesVolume ADD Nkey number(30)') but the new column hasn't been added in the original table , so i can't add variables to this column

Answer 1

[Titus Edelhofer]

Hi,

if you take a look at a.Message, do you see an error message from the database server?

Titus

[nour]

no there isn't any error message

my new column contains the summation of the same row