Validating an sql expression
720258Dec 16 2009 — edited Dec 16 2009Hi,
I am using Oracle Forms 10.2.0.1.0 and Oracle 10g Database.
My application has given the user option to create sql expressions and get the result as TRUE or FAlLSE.
Is there any way i could validate the expression to make sure the syntax is correct.?
If the user select the table as emp
emp_no and Salary are column in emp table
and the expression created is count(emp_no)* Salary >1000
i will using it in if else statement to return True or false
ie
if count(emp_no)* Salary >1000 Then
return True
else
return False;
end if;
Can someone suggest me a way to evaluate the expression generated by the user is syntactically correct or not
Edited by: user8783669 on Dec 16, 2009 1:23 AM