hy i want to do oracle apex certification can any one suggest were can i find online and which is cheap also?
Discy Latest Questions
Hi There, I need to highlight font color of column values in interactive grid based on the below condition: Highlight font color of Column A when the value is not equal to the value of Column B. Dynamic action created on the column A, event - change, where client side condition given as Col A != Col B True action : set style, Style Name: color, Value: red. When I am running the page it is highlighting when I click to change the value of particular cell. When I don't select the particular cell It shows it's original font color rather than showing red in color even though the condition satisfies.
Dear Colleagues, i have a requirement to automated sms alert on birthdays but my code (loop) sends out alot of messages to clients on the day of birthday. i need a simple code to fetch contacts of this employees who are celebrating their bday on sysdate and send sms using my api. Please find my sample code which works but the send a lot of sms to one client. This is done using apex automation feature Thank you Declare api sms_api.sms_api%TYPE; l_clob CLOB; list_con varchar2(2000); message_confirmed varchar2(4000); BEGIN SELECT SMS_API INTO api FROM SMS_API WHERE COMPANY = 'HMI'; FOR rec IN (select CLIENTS_HMI.CONTACT as CONTACT, CLIENTS_HMI.FIRSTNAME from CLIENTS_HMI CLIENTS_HMI where add_months(DATE_OF_BIRTH, 12 * round((trunc(sysdate) - DATE_OF_BIRTH)/365.25)) between trunc(sysdate) + 0 and trunc(sysdate) + 0) LOOP l_clob := apex_web_service.make_rest_request( p_url => 'https://sms.arkesel.com/sms/api?action=send-sms&api_key='||api||'&to='||rec.CONTACT||'&from=HMI-INVEST&sms=Happy Birthday '||rec.FIRSTNAME||', We at (HMI Management Services) wish your birthday will be as awesome as you have been to our business. We wish you the best as you celebrate today. Enjoy your day!!!', p_http_method => 'GET'); END LOOP; END;
Hi! I want to import data from Excel to Oracle APEX. File have 3 columns and that 3 columns should be 3 tables, every column should be one new table. Table 1 and Table 2 have same data in rows. Table 2 should have fk for Table 1 and table Table 3 fk for Table 2. What is the best way to import these data? Sample data: Thanks in advance!