We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If <invoice number within AUTO_EFORM.SUBJECT> = ORDER_CONTACT.INVOICE_NO and ORDER_CONTACT.SO_CONTACT_ID is not blank then replace AUTO_EFORM.CONTACT_ID with ORDER_CONTACT.SO_CONTACT_ID
update auto_eform set contact_id = select order_contact_id from order_contact, auto_eform ae where substr(ae.subject, 10, (instr(ae.subject, ' ', 10)-10)) = order_contact.invoice_no
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Email query results in HTML||6||50|
|I tried to perform dml in a table for auditing who perform dml where a after dml trigger also exists in the same table as per rule i tried to handel with autonomous_transaction but still cant perform.||7||47|
|mask value when navigating||5||23|
|Using Sum with Case When within a query||9||48|
Join the community of 500,000 technology professionals and ask your questions.