/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

1 vote293 views3 answers
Mysql connection string
SQL
3 votes281 views1 answer
Mysql replace string in table
SQL
0 vote308 views1 answer
Best sql collation
SQL
10 votes293 views1 answer
Oracle dependencies table
SQL
0 vote281 views1 answer
Console output pl sql
SQL
0 vote270 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote295 views1 answer
Expression number 1 of select list is not in group by clause
SQL
4 votes263 views2 answers
How to count items with same name in sql
SQL
14 votes292 views2 answers
Oracle export trigger ddl
SQL
0 vote279 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL