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/pavlos/Followers Comments
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. On: January 31, 2021

    Oracle SQL Query to Split a String

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on February 2, 2021 at 4:01 pm

    Great. Thanks for the example 👍.

    Great. Thanks for the example 👍.

    See less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  2. On: August 29, 2020

    Oracle: Running a Procedure in Background

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on November 13, 2020 at 8:20 pm

    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 less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  3. On: August 29, 2020

    Oracle: Running a Procedure in Background

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on November 3, 2020 at 5:43 am

    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 less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  4. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on October 2, 2020 at 6:21 pm

    Yes, you can try this.

    Yes, you can try this.

    See less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  5. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on October 2, 2020 at 5:49 pm

    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 less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  6. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on October 2, 2020 at 5:31 pm

    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 less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  7. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on October 2, 2020 at 4:47 pm
    This comment was edited.

    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 less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  8. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on September 19, 2020 at 3:47 pm

    Please ask as a separate question using Ask Question button.

    Please ask as a separate question using Ask Question button.

    See less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  9. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on September 13, 2020 at 8:49 am

    You are welcome.

    You are welcome.

    See less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
  10. On: September 10, 2020

    Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables

    Vinish

    Vinish

    • 1 Question
    • 468 Answers
    • 44 Best Answers
    • 2k Points
    View Profile
    Vinish Legendary
    Replied to comment on September 12, 2020 at 7:20 am

    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

    var n_deptno;
    
    n_deptno = $v("P19_FORMKEY");
    var model = apex.region("igemp").widget().interactiveGrid("getViews", "grid").model;
    model.forEach(function(igrow) {
         model.setValue(igrow, 'IGKEY', n_deptno);
    });

    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:

    Create or replace trigger trg_bi_emp before insert on EMP for each row
    Declare
    n_deptno dept.deptno%type;
    Begin
    select deptno into n_deptno from dept where formkey = :new.igkey;
    :new.deptno := n_deptno;
    End;

    This is the tested method and works perfectly.

    Please let me know for any further questions.

    See less
    • Share
      Share This Article
      • Share on Facebook
      • Share on Twitter
1 2

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • Hussain

    Need to displayed Total in Interactive Report

    • 2 Answers
  • sathishkeethi

    APEX - How to Upload & Download Document in my ...

    • 0 Answers
  • Kanshu

    Can you explain this 15 puzzle code in shell script ...

    • 0 Answers
  • Sanjay

    ORA-01034 ORACLE not available

    • 2 Answers
  • afzal
    afzal added an answer STEP -1 CREATE REPORT LIKE-- select SAL AS "SALARY", NVL(COMM,0)… March 2, 2021 at 10:25 am
  • apex4ebs
    apex4ebs added an answer I have used a union in the sql of the… March 1, 2021 at 1:38 pm
  • Eyad
    Eyad added an answer Thank you. I noticed that The type sequence works only… February 28, 2021 at 3:27 am
  • SupriyaJain
    SupriyaJain added an answer Called color_ig_cells() in Page change event. It is working now.… February 26, 2021 at 4:29 pm
  • SupriyaJain
    SupriyaJain added an answer When I toggle between Page Numbers at the bottom of… February 26, 2021 at 3:10 pm

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