/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

0 vote135 views3 answers
How to run sql query
SQL
0 vote130 views1 answer
Insert array into mysql column
SQL
5 votes132 views3 answers
Postgres show databases
SQL
1 vote134 views1 answer
Default
SQL
0 vote128 views1 answer
Gcloud check sql
SQL
0 vote132 views1 answer
Postgres sequence name
SQL
0 vote124 views1 answer
If null don't update
SQL
0 vote127 views2 answers
Sql server select first day of previous year
SQL
3 votes141 views1 answer
Oracle cannot access v$session
SQL
0 vote148 views1 answer
Snowflake drop column
SQL