SQL / OracleDB: How to set the same value for all fields in a column?

Question

Is it possible to set a value for all fields in a column, e.g.:

ID Host    URI
1  //cyrus /images    
2  //cyrus /videos
3  //cyrus /text
4  //cyrus /misc
5  //cyrus /backup

I want be able to change all the Host column entries -which are all alike- at one place. This place can be a GUI like the Ocracle SQL Developer or Queries, I don't care as long as I have to change only one datafield that changes all Host fields.

Answer 1

It sounds like you could do something like

UPDATE your_table_name
   SET host = '//new_host'
 WHERE host = '//cyrus'

to update all the rows in the table. Storing the same data in multiple rows of a table, however, violates the basic principle of normalization. You would almost always want to modify the schema design so that there is a separate table for the HOST and a foreign key from your table to the host table. Something like

CREATE TABLE host (
  host_id   NUMBER PRIMARY KEY,
  host_name VARCHAR2(50)
);

CREATE TABLE your_table_name (
  your_id   NUMBER PRIMARY KEY,
  host_id   NUMBER REFERENCES host( host_id ),
  uri       VARCHAR2(100)
);

If you did that, you'd only need to update one row in the HOST table to update the name of the host for all the rows in your table.