title: Change only single column values when we use * in sql
body: <p>Is there a way to change only single column values as updated in selection of oracle sql.</p>
  
  <pre><code>SELECT  ORDD.id||'sdaf' as id,ORDD.* 
  FROM RDT_ORDER ORDM,RDT_ORDERDETAIL ORDD;
  </code></pre>
  
  <p>Here in RDT_ORDERDETAIL am having around Hundered columns but only single coulmn I need as updated.</p>
  
  <p>I don't want to select all Hundred columns by writing all columns in select query as below</p>
  
  <pre><code>SELECT  ORDD.id||'sdaf' as id,ORDD.col1,ORDD.col2,ORDD.col3,ORDD.col4 
  FROM RDT_ORDER ORDM,RDT_ORDERDETAIL ORDD;
  </code></pre>
  
  <p>Please note I have removed where clause,I need to get single updated column values other columns as it is.But I shouldn't write all coulmns in Select.</p>
  
  <p><strong>Existing DB Records :</strong></p>
  
  <pre><code>ID NAME COL3 COL4
  1  name1 ..   ..
  2  name2 ..   ..
  3  name3 ..   ..
  </code></pre>
  
  <p><strong>Now Result :</strong></p>
  
  <pre><code>ID       ID NAME COL3 COL4
  1_'sdaf' 1  name1 ..   ..
  2_'sdaf' 2  name2 ..   ..
  3_'sdaf' 3  name3 ..   ..
  </code></pre>
  
  <p><strong>Expected Result :</strong></p>
  
  <pre><code>ID        NAME COL3 COL4
  1_'sdaf'  name1 ..   ..
  2_'sdaf'  name2 ..   ..
  3_'sdaf'  name3 ..   ..
  </code></pre>