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
BheemProfessional
How much is monthly charge for oracle cloud always free autonomous database upgraded to paid version? On what basis they will charge.
RichmondProfessional
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;
AnaProfessional
Hello Sir! I would like to insert an entry into a column depending on the column of the same table. For that I thought of creating a trigger. This trigger checks which entry the certain column has in the table and then decides what to enter in another in the same table and in the same row. create or replace TRIGGER INSERT_COLUMN2_TABLE1 BEFORE INSERT OR UPDATE ON TABLE1 FOR EACH ROW begin -- IF :NEW.COLUMN ='REQUESTED' THEN :NEW.COLUMN2 := 'REQUEST_PENDING'; ELSEIF :NEW.COLUMN ='NOT_REQUESTED' THEN :NEW.COLUMN2:='TEXT123' END IF; END; but I get following errors when trying to execute the trigger: PLS-00103: Encountered the symbol "" when expecting one of the following: := . ( @ % ; PLS-00103: Encountered the symbol ";" when expecting one of the following: if as well I think this would be an after insert or update trigger? For the reason that it should be fired when an entry is already done in the column.. But how can I in general reference column in a trigger from the same table where I try to fire a trigger on? Maybe the better question is, how can one column value be populated based on another column in the same table. should I really use a trigger for that? --Used a virtual column for that ALTER table1 ADD ( column2 as ( case when column1 ...
Hello Sir, I have a general question. I would like to create a functiion to insert a value in a table depending on the action of the logged in user. This means when the user clicks on accept, then an entry should be made in the column like 'ACCEPTED'. But when the user clicks on the button denied, then another entry should be made like 'DENIED' in the column. I want then create processes in the page which call the different functions and are executed when a button is clicked. So for example for the button submit I call the function which makes an insert 'ACCEPTED' in the column of the table. For the button denied I call another function, which inserts another entry in the table etc. My general question is: how can different insertions be made in the table depending on the button actions? is the presented approach useful for such an issue?
AnaProfessional
Hello Sir:) I want to create read only form, which retrieves data from the table. For that I created a region of type form and used SQL-Query as source. The page is rendered as read only always. But now I get displayed empty items, do I have to insert for each page item a default value type for example (sql-query) in order to set the item? or is there a better solution for this?
Hi I am using clicksend api to send sms from database. but getting certificate validation failure. how to add certificates.
SwarupProfessional
Dear Sir, Good Evening, Can we restrict data entry after one record is created? Ex:An end-user has created one record but he/she shouldn't be able to enter a second record into the application/DB Thanks in Advance
AnaProfessional
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 ...
HussainProfessional
Hi, I have tried couple of time by exporting run time file but when we import then system again give option either you want to import as runtime/Development. I want to send this file to the client so client always have runtime only. Please share if any option. Thanks.