Hello, I have noticed many times that when I execute a delete dql checking the show sql check box, the equivalent sql is a select instead of a delete, and this doesn't make sense to me...for example, the following dql:
delete dm_sysobject objects where object_name like 'delete%'
turns into:
| SELECT dm_dbalias_B.R_OBJECT_ID FROM DMOWNER.DM_ACL_S dm_dbalias_B WHERE (dm_dbalias_B.R_OBJECT_ID=:objectp AND dm_dbalias_B.I_VSTAMP=:versionp) | PARAMS | :objectp=4501c0c080001d01 :versionp=9 |
I had always thought that with just copying the sql in my oracle client I would get the same result as executing the dql in DA, but this example makes me doubt. Can anybody clarify this a little bit, please?
Many thanks!!
