/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 votes192 views1 answer
How to make insert script from table in SQL server
SQL
1 vote187 views2 answers
Pl sql case
SQL
1 vote142 views1 answer
Athena query timestamp greater than
SQL
0 vote189 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote183 views1 answer
Procedure excute monthly oracle
SQL
1 vote183 views1 answer
Oracle sql listagg
SQL
1 vote188 views2 answers
Mysql remove first and last character from string
SQL
6 votes191 views4 answers
Mysql update set
SQL
1 vote200 views1 answer
Add multiple row table pl sql
SQL
0 vote274 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL