Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

An active community you can depend upon!

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE. Hit the button Create a new account to get started.

Create a new Account
  • Recent Questions
  • Most Answered
  • No Answers
  • Most Visited
  • Most Voted
  • Followed Questions

Discy Latest Questions

Chaitanya
Chaitanya

Chaitanya

  • 4 Questions
  • 8 Answers
  • 0 Best Answers
  • 45 Points
View Profile
  • 0
ChaitanyaContributor
Asked: April 20, 2021

Oracle Apex Certification guidence

  • 0

hy i want to do oracle apex certification can any one suggest were can i find online and which is  cheap also?

apexoracle apex
  • 0
  • 4
  • 0
Answer
pavlos
pavlos

pavlos

  • 29 Questions
  • 77 Answers
  • 1 Best Answer
  • 281 Points
View Profile
  • 0
pavlosProfessional
Asked: April 20, 2021

How to write left join in Quick SQL?

  • 0

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.

oracle apexquick-sql
  • 0
  • 5
  • 0
Answer
Richmond
Richmond

Richmond

  • 6 Questions
  • 6 Answers
  • 0 Best Answers
  • 65 Points
View Profile
  • 0
RichmondProfessional
Asked: April 18, 2021

HOW TO IMPLEMENT FILESTACK IN ORACLE APEX

  • 0

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

docsfile mgtfilestackoracle apex
  • 0
  • 135
  • 0
Answer
pavlos
pavlos

pavlos

  • 29 Questions
  • 77 Answers
  • 1 Best Answer
  • 281 Points
View Profile
  • 0
pavlosProfessional
Asked: April 18, 2021

Export workspace with DDL and DML

  • 0

Hi! I want to find a way to export workspace with applications, DDL and DML. Thanks in advance!

oracle apex
  • 0
  • 72
  • 0
Answer
Kamran Ijaz
Kamran Ijaz

Kamran Ijaz

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
Kamran IjazContributor
Asked: April 18, 2021

How I can stop auto selected sub-menu in navigation Top Menu?

  • 0

You can See if i selected menu then first sub-menu tab automatic selected. I just want to remove first selection of sub-menu.  

apex-menutop-menutop-nav-menu
  • 0
  • 8
  • 0
Answer
Richmond
Richmond

Richmond

  • 6 Questions
  • 6 Answers
  • 0 Best Answers
  • 65 Points
View Profile
  • 1
RichmondProfessional
Asked: April 17, 2021

HOW TO SET UTF-8 IN ORACLE APEX.

  • 1

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;

apexapioracleweb services
  • 0
  • 7
  • 0
Answer
pavlos
pavlos

pavlos

  • 29 Questions
  • 77 Answers
  • 1 Best Answer
  • 281 Points
View Profile
  • 0
pavlosProfessional
Asked: April 15, 2021

How to use front-end frameworks with Oracle APEX?

  • 0

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!

bootstraporacle apex
  • 0
  • 14
  • 0
Answer
Appakondu
Appakondu

Appakondu

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
AppakonduContributor
Asked: April 14, 2021

11G Database installing @ windows2012 server r2

  • 0

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  

installing
  • 0
  • 7
  • 0
Answer
Bheem
Bheem

Bheem

  • 17 Questions
  • 13 Answers
  • 0 Best Answers
  • 128 Points
View Profile
  • 0
BheemProfessional
Asked: April 14, 2021

How to add ssl certificate to oracle cloud always free autonomous database server

  • 0

Hi I am using clicksend api to send sms from database. but getting certificate validation failure. how to add certificates.

apex
  • 0
  • 7
  • 0
Answer
Ana
Ana

Ana

  • 9 Questions
  • 14 Answers
  • 0 Best Answers
  • 76 Points
View Profile
  • 1
AnaProfessional
Asked: April 12, 2021

Create history tab in oracle apex

  • 1

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 ...

apexoracletrigger
  • 0
  • 99
  • 0
Answer
1 2 … 8

Sidebar

Ask Question
Write a Post

Recent Blog Posts

  • Vinish

    Oracle Apex - Display External File in Region

  • Vinish

    Oracle PL/SQL Download BLOB File to Disk

  • Vinish

    Oracle Convert External File to BLOB

  • Vinish

    Oracle Apex Calendar Example

  • Vinish

    Oracle Apex - Open Modal Dialog Page Using JavaScript

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2021 OrclQA.Com. All Rights Reserved. Privacy Policy