3 ms·
I've done a fair amount of plsql programming as well, did not see it as a big problem. When processing a lot of data i definitely prefer it to doing the same in
by ako 5y ago
I've done a fair amount of plsql programming as well, did not see it as a big problem. When processing a lot of data i definitely prefer it to doing the same in java/python/... Executing queries with jdbc, mapping resultsets to java objects, writing back changes is cumbersome and bad performance.
Working with plsql packages is like programming in pascal/modula 2 but with first class SQL support built in. A bit like linq in c#.
For example, I don't see how for cursor loops in plsql like documented here: https://www.oracletutorial.com/plsql-tutorial/plsql-cursor-for-loop/ https://www.oracletutorial.com/plsql-tutorial/plsql-cursor-f... are less elegant than doing something similar with java or python.