Showing posts with label numbers and character seperation. Show all posts
Showing posts with label numbers and character seperation. Show all posts

Sunday, 22 February 2015

Seperating numbers from characters in OBIEE 11g


We had a requirement in which the a column had either pure numbers such as 123 or pure alphabets such as QWED. The requirement was to display 'Y' in a column if the value was a number and display 'N' if it was a character string.