Home » SQL & PL/SQL » SQL & PL/SQL » to get the number of rows inserted in a table
to get the number of rows inserted in a table [message #239802] Wed, 23 May 2007 06:09 Go to next message
cutsmartprem
Messages: 62
Registered: November 2006
Member
Hi All,
I have a table and everyday about 10 to 15 new rows are been inserted in the table and there is no column to store the date in which the row was inserted.
Is it possible to get the number of rows inserted on a date in the table.
Request you to kindly help me out...

Thanks in advance....
Re: to get the number of rows inserted in a table [message #239808 is a reply to message #239802] Wed, 23 May 2007 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a trigger on insert.

But I wonder why you want to do this.

Regards
Michel
Re: to get the number of rows inserted in a table [message #239810 is a reply to message #239808] Wed, 23 May 2007 06:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Turn on auditing.

MHE
Re: to get the number of rows inserted in a table [message #239814 is a reply to message #239810] Wed, 23 May 2007 06:26 Go to previous messageGo to next message
cutsmartprem
Messages: 62
Registered: November 2006
Member
can you suggest me with an example

it would help my understanding well.
Re: to get the number of rows inserted in a table [message #239830 is a reply to message #239810] Wed, 23 May 2007 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Auditing will just give you the number of statements but one insert (select) can insert 0, 1 or more rows.

Regards
Michel
Re: to get the number of rows inserted in a table [message #239831 is a reply to message #239814] Wed, 23 May 2007 06:59 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
An example of what?
Moreover, you don't answer to my question, why should I continue to try to help?

Regards
Michel
Previous Topic: finding the nth salary
Next Topic: echo .
Goto Forum:
  


Current Time: Fri Dec 09 15:42:20 CST 2016

Total time taken to generate the page: 0.18726 seconds