1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Schedule job for multi threading

Discussion in 'SQL PL/SQL' started by simplesanju, Feb 12, 2018.

  1. simplesanju

    simplesanju Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    india
    Hi ALL

    I have requirement like

    select COL1,Col2 from A
    minus
    Select COL1,COL2 from B;

    both tables have 50+ millions record so I want to automate a job which will execute this query for 1millions records for one time and then again 1 millions for second time...like loop and store output in record type.


    Thanks in advance
    Sanjana
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,599
    Likes Received:
    363
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Why? You then must keep track of where the previous run left off.

    Explain what reasons there are for such a plan.