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
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: March 24, 2022

    Apex Collection: how to have actual column names instead of C001, C002...

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on March 25, 2022 at 4:35 pm

    hi @Vinish, my feedback... its working fine in your sample/example app. thanks again. with best regards.

    hi Vinish, my feedback... its working fine in your sample/example app.

    thanks again.

    with best regards.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: March 24, 2022

    Apex Collection: how to have actual column names instead of C001, C002...

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on March 25, 2022 at 3:25 pm

    thanks a bunch @Vinish, will check the code and also app you have created. best regards.

    thanks a bunch Vinish, will check the code and also app you have created.

    best regards.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: March 24, 2022

    Apex Collection: how to have actual column names instead of C001, C002...

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on March 25, 2022 at 10:16 am

    dear @Vinish sorry if i failed to describe correctly, during my search for this requirement i found the following @Carsten Czarski blog topic blogs.oracle.com/apex/post/โ€ฆ , here he showed us how to get actual column names but did not illustrate how to use these column names instead of C001, C002 etcRead more

    dear Vinish

    sorry if i failed to describe correctly, during my search for this requirement i found the following @Carsten Czarski blog topic blogs.oracle.com/apex/post/โ€ฆ , here he showed us how to get actual column names but did not illustrate how to use these column names instead of C001, C002 etc. this is what can be used dynamically no matter which query i run. i failed to find a solution yet.

    regards

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: February 28, 2022

    Aapex: PL/SQL Dynamic Content - Pagination or Page Break

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on March 2, 2022 at 6:01 pm

    to have a page break, where you need in PL/SQL Dynamic Content add below code: htp.p('<table class="pagebreaks"> </table>'); and on page inline CSS add @media print { /* Print each group on a new page. */ .pagebreaks { page-break-after: always; } } hope juniors like me get benefit.

    to have a page break, where you need in PL/SQL Dynamic Content add below code:
    htp.p('<table class="pagebreaks"> </table>');
    and on page inline CSS add
    @media print {
    /* Print each group on a new page. */
    .pagebreaks {
    page-break-after: always;
    }
    }

    hope juniors like me get benefit.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: February 25, 2022

    Apex: how to exclude a selected PopUp LOV row from its Query and refresh it dynamically

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on March 2, 2022 at 12:00 pm
    This answer was edited.

    any hope to achieve this? i want it like screenshot below, how i can have this? here in the LOV there are greyed entries which are selected and for next row of grid, its now disabled to select. OR any way around it should not appear in LOV / Select List at least. regards

    any hope to achieve this? i want it like screenshot below, how i can have this? here in the LOV there are greyed entries which are selected and for next row of grid, its now disabled to select. OR any way around it should not appear in LOV / Select List at least.
    LOV-Select-List-with-disabled-items
    regards

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: February 22, 2022

    Calendar page with single date... should display details in region below

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on February 23, 2022 at 1:39 pm

    ok, its Solved now. i was using this.data.startDate which was not working now changed, may be some juniors want to know like me: in Dynamic Action on Calendar Region, on Event = Date Selected [Calendar] and true Action is Set Value, Set Type = JavaScript Expression and JavaScript Expression is: apexRead more

    ok, its Solved now. i was using this.data.startDate which was not working now changed,
    may be some juniors want to know like me: in Dynamic Action on Calendar Region, on Event = Date Selected [Calendar] and true Action is Set Value, Set Type = JavaScript Expression and JavaScript Expression is: apex.date.format(this.data.dates.newStartDate, 'MM/DD/YYYY') and Affected Elements => Selection Type = Item(s) and Item(s) = P2_THEDATE
    in my card region query, added in where clause:
    and b.booking_date = NVL(to_date(:P2_THEDATE, 'MM/DD/YYYY'), b.booking_date)

    Happy Apex'ing.
    regards

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: February 16, 2022

    Subquery in SQL ?, Types of Subquery , Implementation with example?

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on February 23, 2022 at 11:13 am
    This answer was edited.

    a brief intro to subquery: A subquery is a SELECT statement nested inside another statement such as SELECT, INSERT, UPDATE, or DELETE. Typically, you can use a subquery anywhere that you use an expression. example 01 - using 'IN' (this query will return multiple department's data): select empno, enaRead more

    a brief intro to subquery:
    A subquery is a SELECT statement nested inside another statement such as SELECT, INSERT, UPDATE, or DELETE. Typically, you can use a subquery anywhere that you use an expression.

    example 01 - using 'IN' (this query will return multiple department's data):
    select empno, ename, sal from emp where deptno IN (Select deptno from dept)

    example 02 - using '=' (this query will return data only for higher/greatest department no.):
    select empno, ename, sal from emp where deptno = (Select MAX(deptno) from dept)

    can you google the things to find various answers? there are more other ways for using a subquery.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: February 15, 2022

    How i can make page item Display Only while can still be updated through Dynamic Action

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on February 15, 2022 at 5:19 pm

    hi @Vinish, its done by using built in action Disable in dynamic action on page load. currently it seems working fine. thank you for your valuable time you are giving us.

    hi Vinish, its done by using built in action Disable in dynamic action on page load. currently it seems working fine.
    thank you for your valuable time you are giving us.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: February 14, 2022

    Tab Container: how to navigate to Next Tab through button

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on February 15, 2022 at 10:35 am

    thanks a bunch @Vinish for solution inclusive of guidance. 2 thumbs up. kind regards

    thanks a bunch Vinish for solution inclusive of guidance. 2 thumbs up.
    kind regards

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: February 2, 2022

    how to populate data manually in editable IG

    AhmedHaroon

    AhmedHaroon

    • 26 Questions
    • 25 Answers
    • 0 Best Answers
    • 166 Points
    View Profile
    AhmedHaroon Professional
    Added an answer on February 2, 2022 at 10:48 am
    This answer was edited.

    @Vinish i found your earlier post (solution) for the same which i will try. https://orclqa.com/question/how-to-fill-data-into-interactive-grid-based-on-page-item-value/ regards note: need help for How To populate data in an IG with JS from another table to avoid enter data directly into table firstRead more

    Vinish

    i found your earlier post (solution) for the same which i will try.

    https://orclqa.com/question/how-to-fill-data-into-interactive-grid-based-on-page-item-value/

    regards

    note: need help for How To populate data in an IG with JS from another table to avoid enter data directly into table first as mentiond in above link.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3

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