Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up 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
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions

Discy Latest Questions

Chaitanya
Chaitanya

Chaitanya

  • 17 Questions
  • 32 Answers
  • 0 Best Answers
  • 125 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: August 16, 2021

Update selected data in intercative grid with sancation button?

  • 0

Hyy Vinish sir and dear all i have intercatve grid on my page i have many data as you can see what i want to do is update selected data . for example if user selects 3 data and press save button, the 3 data should get updated. the update action i want to perfom is something like this if :old_rate > 0 and :new_rate > :old_rate then UPDATE  TABLE A SET audit_yn='Y', audit_date=to_date(sysdate,'dd/mm/rrrr'), auditor=:APP_USER, authority=XYZ', auth_date=to_date(sysdate,'dd/mm/rrrr'), auth_yn='Y' WHERE ref_no = :ref_no and to_date(to_char(ref_date,'dd/mm/yyyy'),'dd/mm/yyyy') = to_date(:ref_date,'dd/mm/rrrr'); else UPDATE A SET audit_yn='Y', audit_date=to_date(sysdate,'dd/mm/rrrr'), auditor=:APP_USER end if;   Thanks in advance..

oracle apexplsql
  • 3
  • 55
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 17 Questions
  • 32 Answers
  • 0 Best Answers
  • 125 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: August 11, 2021

How to setup email in oracle apex

  • 0

Dear Vinish Sir i'm trying to send email from my apex 19.1,i'm getting following error   ORA-04063: package body "APEX_190100.WWV_FLOW_MAIL" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_190100.WWV_FLOW_MAIL" Can You help me out.? and in my toad if i try to compile this APEX_190100.WWV_FLOW_MAIL package i'm getting error as package body is wrapped cannot do anything any solution please?  

oracle apexplsqlsql
  • 6
  • 161
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 17 Questions
  • 32 Answers
  • 0 Best Answers
  • 125 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: August 9, 2021

redirect from login page to other page with out authentication

  • 0

Dear Vinish i want to create a login page with new user and old user authentication.. for eg if a user has user id and password he can login from login page. but if a user is new to he has to create login credentials.. currenty i have already created  custom authentication as shown in your link 'https://www.foxinfotech.in/2019/09/create-custom-authentication-in-5-easy-steps-in-oracle-apex.html' i have also placed a link on login page 'to create new user press here'  and redirected the link to another page in application but as i have created autentication i'm not able to redirect to other page from login screen thanks in advance can anyone help me out?

apexoracle apexplsqlsql
  • 4
  • 89
  • 0
Answer
pavlos
pavlos

pavlos

  • 37 Questions
  • 107 Answers
  • 1 Best Answer
  • 376 Points
View Profile
  • 0
pavlosGuru
Asked: August 7, 2021

How to redirect page with DA using PL/SQL?

  • 0

Hi! I am trying to redirect page using DA and PL/SQL and set items value. Friendly URLs is switch to on. Thanks in advance!

oracleapex.plsqlurl
  • 2
  • 1k
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 17 Questions
  • 32 Answers
  • 0 Best Answers
  • 125 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: August 6, 2021

change colour of application page item refrenced in desktop navigation menu

  • 0

I have created application item and application Computation in shared component and refrenced it in desktop navigation menu but the thing is i want to change the colour of application item which i have refrenced ..

htmloracle apexplsqlsql
  • 2
  • 31
  • 0
Answer
Bheem
Bheem

Bheem

  • 10 Questions
  • 13 Answers
  • 0 Best Answers
  • 100 Points
View Profile
  • 0
BheemProfessional
Asked: November 15, 2020

HOW to sync new emails immediately using mail client API

  • 0

Hi, I am using mail_client api to read emails from outlook server which is working fine. But i need to sync new emails once they come to inbox immediately. Current load email procedure loads all the emails from inbox which will take tooo much time.  

plsql
  • 2
  • 66
  • 0
Answer
Shimul
Shimul

Shimul

  • 13 Questions
  • 23 Answers
  • 0 Best Answers
  • 98 Points
View Profile
  • 0
ShimulProfessional
Asked: November 10, 2020

How can I show/hide many text item field from Table?

  • 0

How can I show/hide many text item field from Table?

apexplsqlsql
  • 7
  • 106
  • 0
Answer
Hooman Hooshyar
Hooman Hooshyar

Hooman Hooshyar

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
Hooman HooshyarContributor
Asked: October 27, 2020

How to set a counter on login page

  • 0

I created a login page and it has a captcha. Now I want to show captcha when user enter wrong username or password. For that I want to add a page item as a counter that has default value = 0, when user enter wrong username or password, counter becomes counter + 1 and when counter >= 1 then login page shows captcha. So what should I do for that? I have another question: Is it possible that some processes don't execute when a page item's type is hidden?

oracle apexplsql
  • 1
  • 70
  • 0
Answer
Vinish Kapoor
Vinish Kapoor

Vinish Kapoor

  • 1 Question
  • 727 Answers
  • 63 Best Answers
  • 4k Points
View Profile
  • 3
Vinish KapoorEnlightened
Asked: July 14, 2020

Please reply to this post if you have any issues using this website.

  • 3

Welcome to the community.

cssjavascriptorclapexplsqlpython
  • 3
  • 223
  • 2
Answer

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us