title: How to change value of
body: <p>I have a table that looks like this:</p>
  <pre><code>date|type|number
  --------------------
  28-jun-21,dog,23
  28-jun-21,cat,24
  28-jun-21,lion,23
  </code></pre>
  <p>I want to do a select statement that changes the dog value to <code>hyena</code>. So, it'd look like this:</p>
  <pre><code>date|type|number
  --------------------
  28-jun-21,hyena,23
  28-jun-21,cat,24
  28-jun-21,lion,23
  </code></pre>
  <p>Here is my code so far:</p>
  <pre><code>select date, case when type='dog' then type='hyena', number
  from table1;
  </code></pre>
  <p>I am new to SQL and Oracle so any ideas or suggestions as to how to accomplish this would help.</p>