table name: general_info
column name: system_name
description of the problem:
I create a table above that has 5 columns and then insert data to the table.
Then, I realize that I forgot to add the column above. Then, I add the column
to this table. I start input the system_name. However, I'm unable to go back
to update the rows that did not put in the system_name's info. I try to use
set system_name = 'APPLE'
where system_name is NULL
and database_name = 'ORANGE'
It does not give me an error message, but it does not input the data in system_name
column. How can I update my info??
Well, the WHERE criteria may not be fully satisfied. Just checkout the exact spelling of the character string used for comparision. Just check it out. Still if it does not works then post the table description.
I do not see anything wrong in your update statement. See if you have any rows with system_name null and db_name =Orange.
please disregard my previous message. I know why now. Thanks.
please disregard my previous message. I know why now. Thank
I just tested your syntax. Works for me.
You may want to check the "where" part of your statement...
I dont think there is anything wrong with ur update statements it works fine check ur spelling with the datebase name.In Oracle the values used are case sensitive
Click Here to Expand Forum to Full Width