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! How to write left join in Oracle APEX Quick SQL? When I use, for example: view v1 table_1 table_2 I got inner join, but some of my fk can be null and I cannot get correct results.
Dear All, I want to find out if any has implemented https://www.filestack.com/docs/uploads/pickers/web/ with oracle. If yes, kindly provide docs Thank you
Hi! I want to find a way to export workspace with applications, DDL and DML. Thanks in advance!
You can See if i selected menu then first sub-menu tab automatic selected. I just want to remove first selection of sub-menu.
Hi team, Can some convert this to pl/sql with dummy data. Method: POST Endpoint: /v1.1/transaction/process //Request Headers Content-Type: application/json Authorization: Basic base64_encode('your API username:your API Key') Cache-Control: no-cache //Request Body { "account_number":"", "account_issuer":"MTN", "merchant_id":"Your Merchant ID", "transaction_id"=>"000000000000", "processing_code"=>"", "amount"=>"000000000020", "r-switch"=>"FLT", "desc"=>"Float Transfer Test", "pass_code"=>"Your Pass code" } Am having issue with utf-8 encoding. How do we set utf-8 encoding. Error: {"status":"Unprocessable Headers","code":400,"description":"UTF-8 Header encoding required"} CODE declare l_body CLOB; l_clob_bank CLOB; d_utl_to_raw varchar2 (2000); d_encode varchar2(2000); api varchar2(1000) := 'XXXXXX=:XXXXXX'; begin SELECT UTL_RAW.CAST_TO_RAW(api) into d_utl_to_raw FROM dual; SELECT UTL_ENCODE.BASE64_ENCODE(d_utl_to_raw) into d_encode FROM dual; l_body := '{ "account_number":"", "account_bank":"", "account_issuer":"", "merchant_id":"", "transaction_id":"", "processing_code":"", "amount":"000000000000", "r-switch":"FLT", "desc":"Float Transfer Test", "pass_code":"" }'; apex_web_service.g_request_headers(1).name := 'encoding'; apex_web_service.g_request_headers(1).value := 'utf-8'; apex_web_service.g_request_headers(2).name := 'Accept'; apex_web_service.g_request_headers(2).value := 'application/json; charset=utf-8'; apex_web_service.g_request_headers(3).name := 'Content-Type'; apex_web_service.g_request_headers(3).value := 'application/json; charset=utf-8'; apex_web_service.g_request_headers(4).name := 'Authorization'; apex_web_service.g_request_headers(4).value := 'Basic '||d_encode||''; apex_web_service.g_request_headers(5).name := 'Cache-Control'; apex_web_service.g_request_headers(5).value := 'no-cache'; l_clob_bank := apex_web_service.make_rest_request( p_url => 'URL', p_http_method => 'POST', p_body => l_body); if apex_web_service.g_status_code = 200 then dbms_output.put_line('Service invoked successfully'); else dbms_output.put_line('Service call failed with response code ' || apex_web_service.g_status_code); end if; dbms_output.put_line(l_clob_bank); end;
Hi! I am trying to find a way to change theme templates with front-end frameworks. How to use Bootstrap or Imperavi SuperKube with Oracle APEX? Thanks in advance!
i installed oracle 11g database in windows server 2012 r2 facing some issues please give me step by step but i installed windows 10 success fully
Hi I am using clicksend api to send sms from database. but getting certificate validation failure. how to add certificates.
Hello 🙂 I would like to create a history table in my application, which should indicate when which user has done what. For now, I have created an audit table and a trigger that enters the necessary data into this table after an UPDATE, DELETE or INSERT on the specific table. In the history table, however, I want to log every process step and fill it with the information WHO did WHAT WHEN and display it. This table should be updated in the course of the process, so that one can see which steps have already been taken and by whom. But now I am not sure how to create such a history table database-wise, because I want to log every process step executed by any user and display it in the history tab. Should I create a trigger for this as well and a table for each process step (although that would probably be a bad database design). I'm not asking for any code here, just a hint if it's possible and in best case some keywords so I can search for ...