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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Set item for where condition via DA
Vinish
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 lessHow to print the chart in oracle apex
Vinish
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:
It will print the chart page.
See lessUser Interface Defaults in Oracle APEX
Vinish
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 lessUser Interface Defaults in Oracle APEX
Vinish
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 lessHow to retrieve values without using submit page in a shuttle
Vinish
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 lessWays to deploy Oracle APEX app to the customers?
Vinish
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 lessHow to apply a validation only when an item get changed in APEX 5
Vinish
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:
- 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 table. And if the value is not the same then do the validation.
See lessschedule a plsql (export from oracle table to a csv file
Vinish
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:
See lesstruncate table using plsql precedure
Vinish
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 lessschedule a plsql (export from oracle table to a csv file
Vinish
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:
See less