I need a routine which will return 4 values . I want to call this routine in select query like below ...

usage:

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 ?


Please guide.