update the column...need help??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: update the column...need help??

  1. #1
    Join Date
    Oct 2000
    Posts
    144

    Question

    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
    this statment:
    update general_info
    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??

  2. #2
    Join Date
    Sep 2000
    Posts
    47
    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.

    Regards,

    Pinakin

  3. #3
    Join Date
    Feb 2001
    Posts
    75

    no update

    I do not see anything wrong in your update statement. See if you have any rows with system_name null and db_name =Orange.

    Kailash Pareek

  4. #4
    Join Date
    Oct 2000
    Posts
    144

    Talking please disregard my previous message. I know why now. Thanks.

    please disregard my previous message. I know why now. Thank

  5. #5
    Join Date
    Nov 2000
    Posts
    39
    I just tested your syntax. Works for me.

    You may want to check the "where" part of your statement...

  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi

    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

    Regards
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width