Simple Script to return Table from CSV in Oracle

That's T-SQL a 'select ... where @tablevar' can be over int or string. But in Oracle the IN will only work over number values, thus we must cast TO_NUMBER. That was fun =).

SELECT TO_NUMBER(column_value) FROM XMLTABLE(<csv_string>)


Popular posts from this blog

Change Password in Windows Server 2012

Using WinDBG to Debug SharePoint & Cheatsheet

Modify DataView XSLT to Add Url in Grid to Workflow Initiation Form