title: Oracle:Check datatype of a variable
body: <p>How can I check if the variable is a varchar/date/numeric datatype in oracle 10g procedure?
  Like guess I have a variable in a procedure,that will be filled with various data(may be number,string or date).How to find this variable`s datatype in Oracle???</p>
  
  <pre><code>Declare
  returnValue varchar2;
  
  Begin
  Text:=select col_name from tab_name where ID=:ID1;
  EXECUTE IMMEDIATE  Text into returnValue;
  End;
  </code></pre>
  
  <p>Here 'ID1' will be sent dynamically."col_name" can have any data.
  I have to check what kinda value is there in "returnValue" variable.?</p>
  
  <p>Please suggest some answers.</p>