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
Printable View
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
not possible if not using any frontend tool.
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