I would like to know if maybe exist some kind of Oracle built in function which return Data type from returned columns?
For example for below query I would like get back something in form: Number, Text (or VarChar2), Date, etc.
Select 1, 'Text', SysDate
From Dual;
which I would call this way:
Select DataTypeFx(1), DataTypeFx('Text'), DataTypeFx(SysDate)
From Dual;
Sometimes is not obvious if you get back for example Text or Date value, so that way it could be easier to find out.
BB