Rules tagged with: Dynamic SQL
Dynamic SQL.
All 3 check SQL or PL/SQL code (G- codes). Browse the rules below for explanations, examples and recommended fixes.
All 3 Dynamic SQL rules
-
G-6010 Always use a character variable to execute dynamic SQL.Major Maintainability
-
G-6020 Try to use output bind arguments in the RETURNING INTO clause of dynamic DML statements rather than the USING clause.Minor Maintainability
-
G-9501 Never use parameter in string expression of dynamic SQL. Use asserted local variable instead.Blocker Security
3 total
Related tags
Tags that appear on the same rules as Dynamic SQL:
- Observability (1 shared)
- Stored Object (1 shared)
More ways to browse rules
- Trivadis PL/SQL & SQL guideline rules - Rules that implement the Trivadis coding guidelines.
- OWASP-related security rules - Rules that name an OWASP Top 10 risk category.
- Oracle APEX rules - Checks for APEX applications, pages, items and regions.
- PostgreSQL rules - Rules that also apply to PostgreSQL and PL/pgSQL.
- Security rules - All rules in the Security quality area.
- Reliability rules - Rules that prevent bugs and failures at run time.
- Maintainability rules - Rules for code that is easy to read and change.
- Rules by quality area - Security, reliability and maintainability.
- Rules by severity - From Blocker to Info.
- Rule profiles - Essential to Extreme: which rules are checked.
- All rules - Search and filter the complete rule set.