I am using Oracle as back-end and some Business Intelligence tool is being used as front-end. In the business intelligence tool, I need to add the numeric value of the data-types like numeric value of varchar2. So, I was looking in the data dictionary of Oracle to find a table where I can find these number,but coludn't find till now. In MS SQL Server, we have similar table(i.e. systypes) which has the contents I am looking for in Oracle.
Kindly suggest what can be the tables that I can look into.
Now, that's something new for me! I didn't know there are 1670 (!?!) type_names in Oracle (10g rel. 2). I recognize only a few of them, while the rest is completely unknown. I wonder what they are used for ... Terra incognita in its full meaning.