Toad World® Forums

Code assist feedback

Thought I’d have a play with it on some existing packages.

  1. Can we group the types of Rules under Rule Violations. That way I can skip a Rule completely if I want. Group by Rule and Group by Severity grouping options?

  2. Rule 5809 - “Ensure elements in SELECT list…” thinks variables should be qualified by a table name

  3. Rule 2603 - Doesn’t like multi table INSERTs I think:

begin
log_message(‘ABC’);

 INSERT
 WHEN 1=2 THEN
 INTO testing
 (column_one)
 VALUES
 (col)  
 WITH w_abc AS
 (SELECT 123  col
 from dual)
 SELECT col
 FROM w_abc;

 dbms_output.put_line(SQL%ROWCOUNT);

end;

Regards

Richard