- Free
- No sign-up
- Works on any device
No tool matches your search.
- Free
- No sign-up
- Works on any device
Create a QR code for a link, Wi-Fi, WhatsApp, contact and more, or read one from a photo.
- Free
- No sign-up
- Works on any device
Fill in the details to see your QR code.
PNG for phones, chats and websites. SVG and PDF stay sharp at any size, which is best for printing. Tip: point your phone camera at the preview to test it.
3. Style (optional): colors, dots, logo
Choose a photo or screenshot or drag it here
Works with photos of printed codes, screenshots and image files.
Looking for QR codes…
SQL IN Clause Generator
Turn a pasted column of values into a quoted, comma separated list for a SQL IN clause, with duplicate removal and chunks of 1000.
- Free
- No sign-up
- Works on any device
About SQL IN Clause Generator
Pasting a column from Excel or a list of IDs into a query means adding quotes and commas by hand. This generator splits your values at line breaks, tabs or commas, trims them, optionally removes duplicates, and writes a list in parentheses. In automatic mode text values get single quotes with inner quotes doubled while plain numbers stay bare, though codes with leading zeros are kept as text. A column name turns the list into a full condition, NOT IN is available, and long lists are split into chunks of 1000 joined with OR because Oracle rejects larger IN lists.
How to use SQL IN Clause Generator
- Paste the values, one per line or separated by commas.
- Enter a column name if you want the whole condition, and choose quoting and the chunk size.
- Copy the result into your WHERE clause.
Why use this tool?
- Private: everything happens in your browser. Nothing you enter is uploaded.
- Free, with no sign-up, no watermark and no limit on how often you use it.
- Works on phones, tablets and computers: Android, iPhone, Windows, Mac and Linux. Nothing to install.
- Free to embed on your own website, with a ready-made code to copy.
- Available in 10 languages.
Also known as
Frequently asked questions
Why are some values quoted and others not?
In automatic mode, plain numbers stay unquoted and everything else is quoted. A value like 007 is quoted so the leading zeros survive. You can force quotes on all values or none.
What is the 1000 item limit for IN lists?
Oracle allows at most 1000 expressions in one IN list. The tool splits longer lists into several lists of up to 1000 and joins them with OR, or with AND for NOT IN.
Does the tool protect against SQL injection?
It doubles single quotes, which is enough for pasted data in a one-off query. For application code, use parameterized queries and never build SQL from user input.
Is SQL IN Clause Generator free?
Yes. SQL IN Clause Generator on Toolipedia is free to use, with no sign-up and no watermark.
Is it safe to use?
Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.
Does it work on my phone?
Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.
Do I need an account?
No. Just open the page and use the tool. There's no sign-up and no email needed.
Can I put SQL IN Clause Generator on my own website?
Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.