Simple Script to return Table from CSV in Oracle

By -
That's it...in T-SQL a 'select ... where someval...in @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>)

Comments

Post a Comment

Popular posts from this blog

NeuroPower Framework to Effective Leadership

By -
Image
This blog is to provide an introduction to the NeuroPower framework and reduces a highly technical well referenced material into simple, yet real world examples. This framework will assist project managers in building effective teams that work in a harmonious network maintaining respect for each other. Introduction: Phycology is one of the oldest fields of study, there were notes on the reoccurrences of patterns within the brain since prior to Ancient Egypt. These studies linked phycology with religion but nevertheless represented patterns in behaviour and techniques for the modification of behaviour. NueroPower combines the intellect of a master of Artificial Intelligence and Phycology to produce a logical representation of behaviour patterns and leaders can use this model to predict behaviour, allowing leaders to mitigate risk and create a harmonious team. Tension and the Amygdala This was best explained to me as a story; imagine for a moment that you are a bunny ...
Read more

Configure language settings on Sharepoint 2010

By -
To set the region and locale of your Sharepoint 2010 installation you will need to visit each site collections root website. Then for each site collection go to settings -> Site Administration -> Regional Settings. Then from the drop down select the Locale for the site and tick the check box labeled "All sub-sites inherit these Regional Settings." This will configure date formats, language, currency and other formatting issues to the appropriate regional setting. The tricky bit is the setting for the My Sites. Each my site is self-contained in its own site collection therefore it will have it's own regional setting defaulted to US Format. In order to deal with this issue you will either need to manually visit each my site after creation and do the same thing in the UI which is ok for organisations of 10-20 people. But in large organisations it is recommended you implement a feature stabler onto the site definition for SPSPERS#0, the feature can then set the...
Read more