I believe the answer to my question is no since it seems straight forward if it were possible, but I was unsuccessful in doing so.
oraext:query-database(concat('select create_ts from menu where order_num=', substring($ticket,10,15), ' and where table_num=', substring($ticket,20,5)),false(),false(),'jdbc:oracle:thin:sysdba/oracle1@localhost:21/SOAINFRA')
Can anyone else confirm that using AND condition cannot be used in oraext:query-database()?
I just seen my mistake. I have two WHERE clauses!