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: May 16, 2022

    Set item for where condition via DA

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 16, 2022 at 2:24 pm

    To use the SQL queries conditionally, you should use Function returning SQL query as IR source. Check the following tutorial: IR Report Dynamic SQL Query in Oracle Apex

    To use the SQL queries conditionally, you should use Function returning SQL query as IR source. Check the following tutorial:

    IR Report Dynamic SQL Query in Oracle Apex

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: May 15, 2022

    How to print the chart in oracle apex

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 15, 2022 at 8:17 pm

    On the chart page create a button and add the below JavaScript code: window.print() It will print the chart page.

    On the chart page create a button and add the below JavaScript code:

    window.print()

    It will print the chart page.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: May 14, 2022

    User Interface Defaults in Oracle APEX

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Replied to answer on May 15, 2022 at 11:47 am

    Yes, it is only applying the UI default to new forms. I couldn't find the way to apply it already created forms.

    Yes, it is only applying the UI default to new forms. I couldn't find the way to apply it already created forms.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: May 14, 2022

    User Interface Defaults in Oracle APEX

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 15, 2022 at 7:17 am
    This answer was edited.

    You can change anything on the existing page as well. Please tell your requirement in more detail that what exactly you want to do?

    You can change anything on the existing page as well. Please tell your requirement in more detail that what exactly you want to do?

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: May 12, 2022

    How to retrieve values without using submit page in a shuttle

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 13, 2022 at 6:04 am

    Please check this thread discussing the same issue: Refresh Shuttle Without Submitting the Page in Oracle Apex.

    Please check this thread discussing the same issue:

    Refresh Shuttle Without Submitting the Page in Oracle Apex.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: May 12, 2022

    Ways to deploy Oracle APEX app to the customers?

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 12, 2022 at 6:38 pm

    You should not use that much complex logic for SaaS applications. For SaaS applications, VPD (Virtual Private Database) is a good idea. You need to read the following document carefully: https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-oracle-vpd-to-control-data-access.htmlRead more

    You should not use that much complex logic for SaaS applications. For SaaS applications, VPD (Virtual Private Database) is a good idea.

    You need to read the following document carefully:

    https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-oracle-vpd-to-control-data-access.html

    Using this, you would be able to create new customers easily and the application management would be very logical. But for this, you need to plan the whole application architecture verywell.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: May 10, 2022

    How to apply a validation only when an item get changed in APEX 5

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 10, 2022 at 9:42 am

    You can use the following program logics: On page load, assign that item value to a hidden page item and in the validation PL/SQL code, compare the previous value to the current value. Write a page process, before the form save process, to validate that item by querying its value from the database tRead more

    You can use the following program logics:

    1. On page load, assign that item value to a hidden page item and in the validation PL/SQL code, compare the previous value to the current value.
    2. Write a page process, before the form save process, to validate that item by querying its value from the database table. And if the value is not the same then do the validation.
    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: May 4, 2022

    schedule a plsql (export from oracle table to a csv file

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Replied to answer on May 9, 2022 at 10:45 am

    Issue is seems to related to the quotes. Try to modify as follows: BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'exp2', schedule_name => 'INT1', job_type => 'STORED_PROCEDURE', job_action => 'STORELAND.PIL_INTERFACE_WEB', number_of_arguments => 0, enabled => FALSE, auto_drop =>Read more

    Issue is seems to related to the quotes. Try to modify as follows:

    BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
    job_name => 'exp2',
    schedule_name => 'INT1',
    job_type => 'STORED_PROCEDURE',
    job_action => 'STORELAND.PIL_INTERFACE_WEB',
    number_of_arguments => 0,
    enabled => FALSE,
    auto_drop => FALSE,
    comments => 'EXPORT');
    
    DBMS_SCHEDULER.SET_ATTRIBUTE(
    name => 'exp2',
    attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
    
    DBMS_SCHEDULER.enable(
    name => 'exp2');
    END;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: May 7, 2022

    truncate table using plsql precedure

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Added an answer on May 7, 2022 at 7:19 am

    Add the following PL/SQL code to your procedure: Begin if p_value = 'h' then execute immediate 'Truncate table emp'; elsif p_value = 'j' then execute immediate 'Truncate table dept'; end if; End;  

    Add the following PL/SQL code to your procedure:

    Begin
      if p_value = 'h' then
         execute immediate 'Truncate table emp';
      elsif p_value = 'j' then
         execute immediate 'Truncate table dept';
      end if;
    End;

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: May 4, 2022

    schedule a plsql (export from oracle table to a csv file

    Vinish

    Vinish

    • 1 Question
    • 847 Answers
    • 74 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    Replied to answer on May 7, 2022 at 7:11 am

    I think you should provide the write privilege to other users, for example: GRANT READ ON DIRECTORY WWW TO PUBLIC;

    I think you should provide the write privilege to other users, for example:

    GRANT READ ON DIRECTORY WWW TO PUBLIC;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 85

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