java - Delete row with confirmation from Oracle table -
i have sql query used delete users.
delete users username = ?
the problem don't know there row success row removal or not. success @ end.
is there way example confirmation oracle row deleted in java code?
executeupdate() method of preparedstatement gives number of rows deleted.if no rows have been deleted query 0.i think that's easiest solution.
if need know rows have been deleted can user "returning" clause, give rows deleted.
regards
Comments
Post a Comment