title: how to frame a sql query to check if the value of the column is all spaces
body: <p>I have only spaces as values of rows in a column of length 121 chars.</p>
  
  <p>I want to write a query in oracle to check whether the column string is only spaces.</p>
  
  <p>for e.g. if say for column address. a row contains only spaces(all 121 chars are spaces).</p>
  
  <p>i want a query that will check if the row contains only spaces.</p>
  
  <p>select * from table where address &lt;> ' ';</p>
  
  <p>but this isnt working it only checks for 1 space. i want the query to check for all 121 spaces.</p>