title: insert single value across multiple columns in sql
body: <p>I have a table with almost 27 columns(all of integer datatype) with first column being ID(PK).
  I wish to update all the values to some value say 500. 
  is there any query to update without typing all the 27 column names like this.</p>
  
  <pre><code>UPDATE tbl_name SET a=500,b=500,c=500.....z=500 where ID = 1
  </code></pre>
  
  <p>Or else can i make any PL/SQL function which will fetch next next column by itself without providing the column name and set the value ? </p>