Field validation

Hi ,

In an Oracle Applications form I am trying to modify  field1 and field 2 , so that when user enter a value 'XYZ' in field1 to query the record from databse table , the process must search for value 'XYZ' in the column field1 and field2 as well.

If it finds any record in database table with field1 ='XYZ' or field="XYZ'  the record must be displayed.

Is there any built-in Oralce forms to acheive this.

Thanks,

Sushma