ThatJeffSmith

Tag: comma

SQL Developer Quick Tip – Leading Comma Formatting

Some folks find this hard to read [sql] SELECT a, b, c, d, e FROM table; [/sql] If your computed column code or column names are very long, they’ll often trail off the edge of the viewable screen. If you’re missing a comma somewhere, you’re bound to run up against an ORA-. You want to […]

Building your WHERE IN () Lists

Have you ever needed to write a query and filter your results with a WHERE EXISTS or a WHERE IN list of values? Your list will be comma delimited, and you’ll need to quote the strings appropriately. Not so bad if you have a few values, but what if you have 42 or 420 or […]

Related Posts Plugin for WordPress, Blogger...