title: CheckBox in Oracle Forms
body: <p>I have a Database block contains 3 columns. in that all are character columns.
  I have created a multi record block in a form which contains 2 text item and one check box.</p>
  
  <p>The values in the table are like below</p>
  
  <p>col1        col2       col3</p>
  
  <p>value1  value2  N</p>
  
  <p>Value3  value4  N</p>
  
  <p>Value5  value6  Y</p>
  
  <p>In the form, I want to find only the records with Value 'N' in the col3.</p>
  
  <p>I want to find the values using Enter - Query, Execute Query method, But here in my form, col3 is the checkbox. if ticked -Y, not ticked value will be 'N'.</p>
  
  <p>I know, we cannot search 'N' values using Enter - Query, Execute Query method.</p>
  
  <p>Is there Any other way we can search?</p>