/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

14 votes285 views2 answers
Oracle add column with default value
SQL
0 vote312 views1 answer
Get initial in sql
SQL
-1 vote286 views2 answers
Postgres autoincrement primary key
SQL
1 vote283 views1 answer
Postgresql pass array in function
SQL
0 vote219 views2 answers
Jupyter notebook connect to database
SQL
0 vote251 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote280 views1 answer
Multiple like values for single column postgres
SQL
0 vote262 views1 answer
Sql get table last modified time
SQL
1 vote292 views2 answers
Snowflake alter column data type
SQL
1 vote294 views1 answer
How to see logical reads in sql server
SQL