Results 1 to 3 of 3

Thread: Getting error if insert more than 100

  1. #1
    Junior Member
    Join Date
    Jan 2008
    Answers
    2

    Getting error if insert more than 100

    How can we insert 100 records per day, if it insert more than 100 it will throw an error and only 3000 records must be posted for per month only by using SQL not by PL SQL


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Getting error if insert more than 100

    not possible if not using any frontend tool.


  3. #3

    Re: Getting error if insert more than 100

    Write a insert before trigger for the table in the trigger write the logic in such a way count the rows on a particular date, if rows are greater than 100 raise_application error in the same way do for the second


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact