Problems encountered when adding custom rules for SQL language

Do not use the ' select * ... ' statement

Hi,guys,

I am working on a rule with the content above.
As you know, when we write select statements, using * will greatly affect our performance. Therefore, I want to write a custom rule to avoid this problem.

I checked the official website and found that XPath is more suitable for write this rule.
When I created the form according to the steps given on the official website, I found that I had no idea to fill in the contents, which was completely different from the pattern of Java rules I wrote earlier.

Could you kindly give me some advice according to this rule I wrote?
Thank you for noticing this post.

Best,
Kevin

Hey there.

This rule already exists for T-SQL and PLSQL

1 Like

Hi,Colin,

Thank you for telling me this.

Cheers,
Kev