/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 votes140 views3 answers
Alter foreign key
SQL
0 vote142 views3 answers
Condition in count sql
SQL
0 vote152 views2 answers
Dbms interview questions
SQL
24 votes149 views6 answers
Alter table name sql
SQL
2 votes187 views1 answer
Oracle Column Names of a table
SQL
92 votes368 views6 answers
Substring
SQL
14 votes137 views3 answers
Trim sql
SQL
0 vote93 views1 answer
Sql truncate table referencing itself
SQL
0 vote149 views1 answer
Sqlite get date only
SQL
3 votes145 views1 answer
Locate sql server
SQL