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.
Oracle SQL Query to Split a String
Vinish
Great. Thanks for the example 👍.
Great. Thanks for the example 👍.
See lessOracle: Running a Procedure in Background
Vinish
Yes, it should be a standalone procedure because we are specifying program_type as STORED_PROCEDURE.
Yes, it should be a standalone procedure because we are specifying program_type as STORED_PROCEDURE.
See lessOracle: Running a Procedure in Background
Vinish
I have tested this on Oracle database 12c onwards, and it is working fine. Please note that when I am running the scheduled procedure, I have taken the v_item_id and v_qty as varchar2, not as a number. Because when I declared them as the number, it was not working. So please check if you declare thRead more
I have tested this on Oracle database 12c onwards, and it is working fine.
Please note that when I am running the scheduled procedure, I have taken the v_item_id and v_qty as varchar2, not as a number. Because when I declared them as the number, it was not working.
So please check if you declare the parameters as numbers.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
Yes, you can try this.
Yes, you can try this.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
Yes, that approach is also fine, where you save the master data first and then display the grid. In this case, you will get the master key value, which you can assign as the default value for the grid column. The grid column default value type to the item and specify the master form item. You will hRead more
Yes, that approach is also fine, where you save the master data first and then display the grid. In this case, you will get the master key value, which you can assign as the default value for the grid column.
The grid column default value type to the item and specify the master form item.
You will have to get the master key value on the form and assign it to the grid FK column. Forget the trigger in this case.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
You will have to find some other way; this is not the recommended approach. Try using sequence object only, whether in form or the DB trigger.
You will have to find some other way; this is not the recommended approach.
Try using sequence object only, whether in form or the DB trigger.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
For the error, if you are using the sequence object, remove the DA created in 12th step to execute the JavaScript code. For the second question, if you are using the sequence object, it will not be duplicate for any other user.
For the error, if you are using the sequence object, remove the DA created in 12th step to execute the JavaScript code.
For the second question, if you are using the sequence object, it will not be duplicate for any other user.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
Please ask as a separate question using Ask Question button.
Please ask as a separate question using Ask Question button.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
You are welcome.
You are welcome.
See lessOracle Apex: Master-Detail Form Example on EMP and DEPT Tables
Vinish
In this case, the whole logic changes. But to make a shortcut, you can follow these steps: Create a new field (formkey) in the DEPT table. Create a new field (igkey) in the EMP table. Create a sequence deptfrmkey. On the dialog screen, for the DEPT table, make this field hidden and set the default vRead more
In this case, the whole logic changes. But to make a shortcut, you can follow these steps:
Create a new field (formkey) in the DEPT table.
Create a new field (igkey) in the EMP table.
Create a sequence deptfrmkey.
On the dialog screen, for the DEPT table, make this field hidden and set the default value as sequence and give the name of the sequence. Also, you can use the SQL query, for example, select deptfrmkey.nextval from dual.
In the EMP grid, synchronize columns, and make the igkey field hidden and set the default value as item DEPT table formkey.
Change the before submit DA as following
Now for new records, the default value will populated for DEPT table and it will be copied to EMP table igkey.
Now create a before insert trigger on the EMP table to get the deptno on behalf of the igkey. Below is an example:
This is the tested method and works perfectly.
Please let me know for any further questions.
See less