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/Bhavin/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: November 2, 2020

    Oracle SQL Query where not already exists

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on November 2, 2020 at 6:52 pm

    Many thanks for your prompt reply but this query won't work...! Any way I found the solution based on the above query: SELECT DISTINCT p.person_id ,c.contact_det_type_id ,c.description FROM per_contact_dets p ,contact_det_types_lk c WHERE p.person_id = :person_id AND c.contact_det_type_id NOT IN (SERead more

    Many thanks for your prompt reply but this query won't work...!

    Any way I found the solution based on the above query:

    SELECT DISTINCT
    p.person_id
    ,c.contact_det_type_id
    ,c.description
    FROM per_contact_dets p
    ,contact_det_types_lk c
    WHERE p.person_id = :person_id
    AND c.contact_det_type_id NOT IN (SELECT p1.contact_det_type_id
    FROM per_contact_dets p1
    WHERE p1.person_id = p.person_id)
    ;

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on October 1, 2020 at 8:45 pm

    Many thanks Farooq, I will have a look.

    Many thanks Farooq, I will have a look.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on October 1, 2020 at 5:16 pm

    Hi Vinish, Many thanks for your prompt reply and providing the instant solution. I have checked there is no header process in my page. I think (not sure) the issue is setting the Source of the page item. By default Wizard does not set the Source for the page item so in Source attribute, Type is setRead more

    Hi Vinish,

    Many thanks for your prompt reply and providing the instant solution.

    I have checked there is no header process in my page.

    I think (not sure) the issue is setting the Source of the page item.

    By default Wizard does not set the Source for the page item so in Source attribute, Type is set to NULL and Used is set to Only when current value in session state is Null.

    And in my case I have set the Type to Database Column and Used is set to Always, replacing any existing value in session state.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on October 1, 2020 at 3:37 pm

    Hi Vinish, Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data? My settings for a branch:

    Hi Vinish,

    Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data?

    My settings for a branch:

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on September 30, 2020 at 9:50 pm

    Hello Vinish, I have implemented the same method  for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.

    Hello Vinish,

    I have implemented the same method  for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Added an answer on September 30, 2020 at 7:53 pm

    Hello Vinish, Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered. How can I keep the page item values even I do back and forth in wizard? Your help would be appreciaRead more

    Hello Vinish,

    Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered.

    How can I keep the page item values even I do back and forth in wizard?

    Your help would be appreciated.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on September 22, 2020 at 1:44 pm

    Hello Vinish sir, My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table. ManyRead more

    Hello Vinish sir,

    My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table.

    Many thanks for your all help and support.

     

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on September 17, 2020 at 8:15 pm

    Hi Vinish, I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection. Would it be possible for you to make a demo on this?  

    Hi Vinish,

    I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection.

    Would it be possible for you to make a demo on this?

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: September 16, 2020

    Wizard Style Form in Apex

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Replied to answer on September 16, 2020 at 8:53 pm

    Hi Vinish Sir, Many thanks for your prompt reply and providing the guidance to implement wizard steps. I will update you accordingly.

    Hi Vinish Sir,

    Many thanks for your prompt reply and providing the guidance to implement wizard steps.

    I will update you accordingly.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: September 3, 2020

    How to save data from Interactive grid to Database Table in one go Master Detail form?

    Bhavin

    Bhavin

    • 4 Questions
    • 12 Answers
    • 0 Best Answers
    • 47 Points
    View Profile
    Bhavin Contributor
    Added an answer on September 4, 2020 at 4:41 pm

    When I click the SAVE button, I am getting an error - Cannot insert NULL into Master_Id. I have tried default Save process but did not work so then I have tried manual PL/SQL Code process. # Manual PL/SQL Code for Master DECLARE l_master_id master_table.master_id%type; BEGIN INSERT INTO master_tableRead more

    When I click the SAVE button, I am getting an error - Cannot insert NULL into Master_Id.

    I have tried default Save process but did not work so then I have tried manual PL/SQL Code process.

    # Manual PL/SQL Code for Master

    DECLARE

    l_master_id master_table.master_id%type;

    BEGIN

    INSERT INTO master_table (col1, col2, col3)

    VALUES (:P1_COL1, :P1_COL2, :P3_COL3)

    RETURNING master_id INTO l_master_id;

    :P1_MASTER_ID := l_master_id;

    END;

    # Manual PL/SQL Code for Detail

    BEGIN

    INSERT INTO detail (master_id, col1, col2, col3)

    VALUES (:P1_MASTER_ID, :COL1, :COL2, :COL3)

    RETURNING rowid into :ROWID;

    END;

    See less
    • 0
    • Share
      Share
      • 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