Generate random hex color values in Oracle sql database
<p>I'm aware similar questions have been asked, but I can't seem to find something that works. I'm creating a table in oracle database which one column is an ID and the other column's value is a hexadecimal color value. When I created the table I put the datatype for the ID as a number and VARCHAR2 for the color. I just want to know if there is a way to generate random hex color values and update the table so that they can be in the color column. Thanks.</p>