How to run Oracle "Describe table" statement from R program (via RJDBC)

General
1

I could successfully connect to Oracle server via RJDBC.

But when I tried to use Oracle's "describe mychema.mytable" to list a table's column names by function "dbGetQuery", I got error message below:

JDBC ERROR: ORA-00900: invalid SQL statement
Statement: describe myschema.mytable

Anyone know how to do it correctly ?

Thanks in advance,

2

Any people has an idea ? Thanks !

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.