Posts by Kauan Polydoro • 76 points
5 posts
-
1
votes2
answers51
viewsA: Update Oracle Error
Oracle does not support simultaneous update of 2 tables, it would be necessary to either perform 2 transactions or create a precedent that performs this procedure for you: UPDATE SAC_RV_DIVIDENDO…
oracleanswered Kauan Polydoro 76 -
0
votes1
answer263
viewsA: Run Automatic Update - Oracle
In this case you can use a Job Scheduler to perform this procedure on a daily frequency. The ideal is that you change the values of’S' and 'N' to 1 or 0 thinking about the performance issue, but…
-
0
votes2
answers717
viewsQ: Search and people who have the same name, surname and date of birth
How can I perform a select on Oracle that brings all people who have the same name, surname and date of birth however, have different ID’s.
-
2
votes3
answers1241
viewsA: Add a column with row number in select result
Thank you Jeferson Almeida! I ended up discovering another way to do this too, for those who are interested, follow the code: select rownum linha, a.estado estado from (select b.estado from estados…
-
2
votes3
answers1241
viewsQ: Add a column with row number in select result
How can I add the row number of the select result in an additional column? For example: select e.ds_estados from estados e This select would return me the registered states AC AL AM ... TO I would…