/SQL/How to pass list as parameter in SQL query

How to pass list as parameter in SQL query

private static String sqlFormatedList(List<String> list){
     StringBuilder sb = new StringBuilder();
     sb.append("('");
     for (String i : list){
       sb.append(i+"','");
     }
     sb.deleteCharAt(sb.length() -1);
     sb.deleteCharAt(sb.lastIndexOf(","));
     sb.append(")");
     return sb.toString();
    }

Source: stackoverflow.com

Similar codes

2 votes279 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote158 views1 answer
Why mysql is used?
SQL
11 votes246 views2 answers
Sql between date range
SQL
4 votes171 views1 answer
For loop postgresql
SQL
25 votes199 views5 answers
Mysql replace text
SQL
6 votes163 views2 answers
Oracle trigger
SQL
1 vote175 views1 answer
Sql first day quarter
SQL
1 vote163 views1 answer
Age postgres
SQL
0 vote151 views2 answers
Postgres default user
SQL
0 vote176 views1 answer
Sql server current time without date
SQL