3 ms·
What would be the better thought process for writing sql procedures? It seems like PL/SQL is fairly procedural.
by Something1234 10y ago
What would be the better thought process for writing sql procedures? It seems like PL/SQL is fairly procedural.
- nickpeterson 10y agoThe rule of thumb would be, use SQL statements to model and execute business logic, not cursors/variables. While the execution is still procedural, the goal is to make all the decisions 'at once' rather than explicitly looping. Behind the scenes a similar set of steps are taken, but the dbms is free to perform the operations as it sees fit.