Oracle Apex Tips & Tricks

Step 1: Create the below function in your database. create or replace FUNCTION amount_in_words (i_amt IN NUMBER)    RETURN VARCHAR2 IS    n_dollar   NUMBER;    n_cents    NUMBER;    FUNCTION check_if_single (i_num IN NUMBER, currency IN VARCHAR2)       RETURN VARCHAR2    IS       FUNCTION n_spell (i_num IN NUMBER)          RETURN VARCHAR2       AS          TYPE w_Array IS TABLE OF VARCHAR2 (255);          l_str w_array                := w_array ('',                            ' thousand ',                            ' million ',                           ...

Step 1: Register for SMS sending API & get your credentials. (Here I used Twilio) Step 2: Create Network ACL. Step 3:  Create an Oracle Wallet Containing the Certificates Step 4: Create Procedure CREATE OR REPLACE PROCEDURE send_sms (     p_user       IN   VARCHAR2, -- Twilio user name     p_pass       IN   VARCHAR2, -- Twilio password     p_from       IN   VARCHAR2, -- Twilio From phone number     p_to         IN   VARCHAR2, -- Phone number of SMS recipient(s) colon delimited.     p_sms_body   IN   VARCHAR2 ) IS     t_http_req         utl_http.req;     t_http_resp        utl_http.resp;     lv_resp_line       VARCHAR2(32767);     lv_response_text   CLOB;     v_url...

Step 1 : Login to your oracle apex workspace. Step 2: Go to Shared Components --> Security --> Authentication Schema Step 3: Click on the current authentication scheme Step 4: Scroll down & select session sharing TYPE = Custom & provide cookie name of your choice. this setting is to be set in all the applications in which you need to use a single sign-on. save and run the app.