OraFAQ Forum: SQL & PL/SQL » To store table row count in the same table's comment

Home » SQL & PL/SQL » SQL & PL/SQL » To store table row count in the same table's comment (any version Oracle)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To store table row count in the same table's comment [message #681288]

Fri, 03 July 2020 18:54

Olexandr Siroklyn
Messages: 45
Registered: September 2018
Location: USA

Member

Hello,

Is there any way to store, after table modifications, table row count inside the same table's comment?
First wrong idea is a table "after-insert-delete" trigger with "execute immediate 'comment on ...'" operation.

Thank you.

Report message to a moderator

Re: To store table row count in the same table's comment [message #681289 is a reply to message #681288]

Fri, 03 July 2020 19:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Olexandr Siroklyn wrote on Fri, 03 July 2020 16:54

Hello,

Is there any way to store, after table modifications, table row count inside the same table's comment?
First wrong idea is a table "after-insert-delete" trigger with "execute immediate 'comment on ...'" operation.

Thank you.

It is possible to do you you desire as long as you are willing to sacrifice application performance.
Doing so will serialize INSERT & DELETE operations to go in single file as the row count value is changed.
I just hope that you don't need many folks concurrently doing INSERT or DELETE operations against this table.

Report message to a moderator

Re: To store table row count in the same table's comment [message #681292 is a reply to message #681289]

Sat, 04 July 2020 09:21

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

What would be the point of storing the table's row count like this? It would need to be updated on EVERY insert or delete. I guarantee you will not be able to keep it accurate. And why would you want to? What problem are you trying to solve?

Report message to a moderator