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!

how to find how many times loop insert into dml statement end loop used in package

Discussion in 'SQL PL/SQL' started by esha, Aug 28, 2014.

  1. esha

    esha Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    Hi,
    How to find how many times loop dml statement end loop end used in oracle package.


    Thanks,
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: how to find how many times loop insert into dml statement end loop used in packag

    With or without modifying the package?
     
  3. esha

    esha Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    Re: how to find how many times loop insert into dml statement end loop used in packag

    Hi ,
    without modifying package.

    Thanks
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: how to find how many times loop insert into dml statement end loop used in packag

    Audit Log...or...since you're talking about INSERTS...count the records in the table before and after the process and do the math. You'll probably want a controlled environment.

    A little curious as to why though......