when I try the Edit command with a positional “order by” (e.g: "edit my_table ORDER BY 1 ") , it is not ordering by the FIRST column!! because for sure in the Edit command they add a hidden column in the first position ( pseudo column rowid maybe) internaly --> then “first position” of the order by is NOT my table’s first column anymore!! but it is now the SECOND one!
select * from my_table ORDER BY 1 = edit my_table ORDER BY 2
“order by 1”(select clause ) is equal to order by 2 (edit command).
this can easily cause huge damages editing tables in production environment!
is this a known issue?
version: Toad for Oracle 188.8.131.52