I am using TOAD for Oracle Base version 10.6.1.3
I want to know what SQL query does get exectued to show us table column data type
I created a table with column Interger, In DBA/ALL/USER table cols Oracle doesn’t maintain that data type integer
rather It plays on Scale and Precision and SQL Developer too follow this patter but I think TOAD is smart enough to detect so I am curious and want to use that SQL in my reporting page.
Any help would be much appreciated