Database Administration (MOSC)

MOSC Banner

Restriction on update privilege

edited Sep 8, 2020 5:02AM in Database Administration (MOSC) 17 commentsAnswered

Hello,

i have one colleague who is requesting access to update one table but latter wants to be able to restrict number of rows that he can update at a time. For e.g if there are 100 rows to be updated based on the select query, he wants to do the update in batches of 10.

is this feasible pls?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center