New answers tagged sql
2
votes
Is this PL/SQL Stored proc optimal?
As mentioned, consider MERGE to handle the conditional INSERT and UPDATE actions. Doing so, ...
- 940
3
votes
Querying for vendors and categories
I agree with the points mentioned by J_H. SQL Injection may be arguably the biggest concern, at least in terms of security. Check out The Hitchhiker's Guide to SQL Injection prevention for tips on ...
- 27k
3
votes
Querying for vendors and categories
consistent defaults
$searchInput='xyz';
Prefer to initialize to the empty string,
for consistency with $searchcat_id.
Repeating
...
- 16.7k
Top 50 recent answers are included