I need a routine which will return 4 values . I want to call this routine in select query like below ...
select col1 , col2 , routine(col3) from mytable
which routine I need ? Do I need view / store proc / function or what is the proper way to solve this ?