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
Home/Mohsin/Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments

Discy Latest Questions

Mohsin
Mohsin

Mohsin

  • 3 Questions
  • 3 Answers
  • 0 Best Answers
  • 37 Points
View Profile
  • 0
MohsinContributor
Asked: February 19, 2021

Subquery in PL/SQL function which returns error text

  • 0

Hi, Is there any way I can use Subquery in pl/sql function body returning error text? My condition is, I have to display only those customer records which does not exists in my target table through select list. My expectation is like this if :P1_CUST_NM IN (SELECT cust_nm from customer) then return 'Customer already exist!s!'; end if; return null; How can i do that? Really appreciated. Thanks

apexvalidation
  • 1
  • 43
  • 0
Answer
Mohsin
Mohsin

Mohsin

  • 3 Questions
  • 3 Answers
  • 0 Best Answers
  • 37 Points
View Profile
  • 1
MohsinContributor
Asked: October 29, 2020

Row remain highlighted on the same page for Interactive Grid after refresh/Load

  • 1

I have created a page which has multiple reports. The first IG report (i.e. Clients) it the starting report. When user click on any column from any page (for example I have 10 pages) then it will display the rest of the reports (i.e. Client Data, Client Address etc). The issue is when user click on a column on page no 4, after refresh it will display page no 1 . Expectation is when user click on any column from any page, the row is highlighted and that page even after refresh. I try my best to find the solution but didn't get any clue. Your help is greatly appreciated. Thanks

apexoracle apex
  • 3
  • 44
  • 0
Answer
Mohsin
Mohsin

Mohsin

  • 3 Questions
  • 3 Answers
  • 0 Best Answers
  • 37 Points
View Profile
  • 1
MohsinContributor
Asked: October 1, 2020

Set same column value from one column to another column in Oracle Apex interactive grid

  • 1

I created a Editable Interactive grid. My goal is to create a new record and pass a date to one column (i.e. current_date) which automatically use the same date value for other column (i.e. admission_date). How can i achieve that? I am new to Apex and trying to explore different features. I know this can be done through Dynamic Action (Set Value) but i don't know what i suppose to select 'SET TYPE' drop down.  

apexig
  • 4
  • 789
  • 0
Answer

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • pavlos

    How to change color of image in Oracle APEX?

    • 0 Answers
  • Bheem

    How to deploy oracle apex app in oracle SaaS

    • 0 Answers
  • Rameez Tariq

    How to create View with Blob column through DBLINK

    • 0 Answers
  • Huy Nguyen

    Dynamic action on column on Interactive Grid

    • 3 Answers
  • hamed
    hamed added an answer hi i want to display image in the report as… March 6, 2021 at 8:33 pm
  • Huy Nguyen
    Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
  • Vinish
    Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
  • Vinish
    Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
  • Vinish
    Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am

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