Loading

SELECT * FROM INFORMATION_SCHEMA

r_chakra

The above select statement is supposed to help us get the schema information of all standard RDBMS . However, when i use this for Oracle, i get numbers, instead of data type keywords. Also, the numbers are sometimes the same for multiple datatypes, making ot difficult to decode the datatype of columns in a table. Does anybody have an idea of how to get the datatypes for Oracle using the above syntax, or any workarounds ? Thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tanvir Huda23y ago
when u send some standard keyword in ur query it returns some wired result and sometimes it falls over. I found that in Access not that sure about Oracle. Better u try with this query SELECT * FROM [INFORMATION_SCHEMA] May be it works
+1