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

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses

Discy Latest Questions

Sbonelo Mchunu
Sbonelo Mchunu

Sbonelo Mchunu

  • Durban, South Africa
  • 6 Questions
  • 13 Answers
  • 0 Best Answers
  • 88 Points
View Profile
  • 0
Sbonelo MchunuProfessional
Asked: April 22, 2022

Selecting a local variable in a Function Body PLSQL returning SQL query Oracle APEX

  • 0

Hi Is it possible to select a local variable in a sql query  when using Function Body PLSQL returning SQL query type. Example: declare         l_query         varchar2(4000);         l_practice   varchar2(100);                 cursor c1 is         select * from TABLE; begin     for r1 in c1         loop                //some code here              l_practice   := l_practice + r1.c001;        end loop;            l_query :='select '|| l_practice||'                          from TABLE';      return l_query; end;

plsqlsql
  • 0
  • 45
  • 0
Answer
ranj
ranj

ranj

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
ranjContributor
Asked: April 14, 2022

Where do we wrapper unix scripting with plsql

  • 0

where wrapper script is used with plsql.and reference material/link to go through?  

plsql
  • 0
  • 9
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: December 25, 2021

Open filled excel file using plsql

  • 0

Hello,I have one excel file with headings in it. I have one form which contains all fields related to excel file So what I want to do is when users fills the form and submits it should automatically open excel file filled with the data entered in form. Thanks in advance  

oracle plsqlplsqlsql
  • 0
  • 26
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 Points
View Profile
  • 0
ChaitanyaProfessional
Asked: November 2, 2021

Covert Image to zip file and insert into database?

  • 0

Hello Everyone I Have Created a Form in my  oracle apex application in which i'm Uploaing multiple images into database. I Want To Upload Images In compress Format (.zip) into database. Means user Selects Images like .jpg, .png etc. and when he uploads Images it Should be Converted Into zip and then store into database Thanks in Advance.

apexoracle apexplsql
  • 1
  • 87
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 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
  • 45
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 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
  • 106
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 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
  • 55
  • 0
Answer
pavlos
pavlos

pavlos

  • 64 Questions
  • 124 Answers
  • 1 Best Answer
  • 534 Points
View Profile
  • 0
pavlosEpic
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
  • 502
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 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
  • 26
  • 0
Answer
Chaitanya
Chaitanya

Chaitanya

  • 31 Questions
  • 42 Answers
  • 0 Best Answers
  • 195 Points
View Profile
  • -1
ChaitanyaProfessional
Asked: August 3, 2021

dispaly specific time according to date

  • -1

Hyy Good morning i want to create online booking system,i want to create date and time picker some thing likethis as shown in image Thanks in advance..

apexoracle apexplsqlsql
  • 0
  • 18
  • 0
Answer
Old Questions

Sidebar

Ask Question
Write a Tutorial

Recent Blog Posts

  • Vinish

    What is Oracle ERP?

  • Vinish

    The Benefits of Unit Testing

  • Vinish

    Java OOPS Concepts MCQ Quiz

  • Vinish

    What is the Best Database to Use?

  • Vinish

    Sending Query Strings in Post Requests in C#

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

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