Oracle SQL - Convert given list (CSV) into Rowshttp://mail.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 || '' ) AS xmlval FROM DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Free Translator API using Googlehttp://mail.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using your...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. Why? I want an image to display per row as a status marker...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho Projects: Deluge to Submit Custom Fieldshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom = {"UDF_CHAR8":12345678901234567,"UDF_CHAR7":"Joel Lipman"}; m_Params = { "name":...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *