How To Send Email in Oracle Application Express (APEX) Using Email Template and Send E-Mail Process

Oracle APEX Book
===============
Create Rapid Low-Code Web Applications in Oracle APEX 21.2: A platform to develop stunning, scalable data-centric web apps fast
www.amazon.com/Create-Rapid-L...
In this video you will learn about sending emails from you Oracle APEX application. You can enable users to send emails from your application by using Send E-Mail process and Email Templates with declarative substitutions. You can implement this process declaratively without writing a single line of code. In this video we are going to send an order confirmation email to customers whose email addresses exist in the DEMO_CUSTOMERS table. The email will contain a link that customers can use to access their placed orders.
Body Anchor Tag:
-----------------------------
href="apex.oracle.com/pls/apex/f?p=... &P14_ORDER_ID."
Footer Anchor Tag:
------------------------------
href="apex.oracle.com/pls/apex/f?p=...."
SQL Queries:
----------------------
P14_CUSTOMER_NAME
SELECT c.CUST_FIRST_NAME||' '||c.CUST_LAST_NAME
FROM demo_customers c, demo_orders o
WHERE c.customer_id=o.customer_id and o.order_id=:P14_ORDER_ID
P14_CUST_EMAIL
SELECT c.CUST_EMAIL
FROM demo_customers c, demo_orders o
WHERE c.customer_id=o.customer_id and o.order_id=:P14_ORDER_ID
P14_ORDER_DATE
SELECT o.order_timestamp
FROM demo_orders o
WHERE o.order_id=:P14_ORDER_ID
P14_ORDER_TOTAL
SELECT o.order_total
FROM demo_orders o
WHERE o.order_id=:P14_ORDER_ID
P14_SHIP_TO
SELECT c.cust_street_address1||' '||c. cust_street_address2
FROM demo_customers c, demo_orders o
WHERE c.customer_id=o.customer_id and o.order_id=:P14_ORDER_ID
P14_SHIPPING_ADDRESS_LINE_1
SELECT c.cust_street_address1
FROM demo_customers c, demo_orders o
WHERE c.customer_id=o.customer_id and o.order_id=:P14_ORDER_ID
P14_SHIPPING_ADDRESS_LINE_2
SELECT c.cust_street_address2
FROM demo_customers c, demo_orders o
WHERE c.customer_id=o.customer_id and o.order_id=:P14_ORDER_ID
P14_ITEMS_ORDERED
SELECT sum(oi.quantity) items_ordered
FROM demo_customers c, demo_orders o, demo_order_items oi
WHERE c.customer_id=o.customer_id and o.order_id=oi.order_id and o.order_id=:P14_ORDER_ID

[@franciscoastudillo9004]

Excelent video!! thanks for the tutorials

[@TechMining69]

Thank you very much!

[@usmannewton5361]

great video.

[@TechMining69]

Glad you enjoyed it

[@angrybird-to7qu]

Hi this is such a nice video, I have one request can yoh make a tutorial how to make this sales app?

[@Darshan0070]

hi, can you please make a advance tutorial of making a fancy dashboard in oracle apex

[@TechMining69]

Sure.

[@AbdulKadirsWorld]

Boss, nice. But video reflection unmatured !

[@TechMining69]

Sorry didn't get your point.

[@salexkorsan8790]

How to receive email??