Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arithmetic grammar validation

3198080Aug 1 2017 — edited Aug 2 2017

Hi all,

I have the following string which is defined by the user. i need to validate the grammar of the string using PLSQL. The string is defined by the user. The string is used for defining formulas for calculations.

String 01 - AB+CD

String 02 - (AB+CD)

String 03 - A*B*C(AB+CD)/EF

String 04 - (A*B*C(AB+CD)/EF) - A

String 05 - (A*B*C((AB+CD)/EF) - A

String 06 - (A*B*C((AB+CD)/EF) - A* ABC)/

The above strings are examples for the user defined formulas.

The String 01,String 02,String 03 & String 04 are valid formulas while String 05 & String 06 are invalid.

Please help me to resolve this.

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2017
Added on Aug 1 2017
18 comments
542 views