[PudgePacket]

Maybe a silly question but what is the point of an insert-only table. Surely it must be read/used in some capacity ? Do they mean "insert heavy"?

[brianwawok]

Means not updated. Say Www visitor logs. No reason to ever update a previous log. What happened happened.

[PudgePacket]

.

[CameronNemo]

Selects would still work. But non insert DML would be disallowed I assume (delete, update).

[blattimwind]

Data is only inserted, not changed or deleted.

[PudgePacket]

.

[22c]

You seem to be missing that data can still be read after it is insterted, provided it is not updated. So think if more like WORM rather than write-only.

[sandGorgon]

for compliance. you want this behavior to be enforced at the database level so that any buggy code does not edit a previous row.