oracledbeaver

What is the reason for not working of 'describe' command on oracle?


i am trying to run the 'describe table_name' command on oracle. I am using dbeaver for accessing oracle. But, when i run the command, it shows SQLException and error message "invalid sql statement". How can i perform the operation?


Solution

  • describe is not a SQL statement, otherwise it would have been documented in the SQL language reference:

    The documentation for the describe command can be found in the SQL*Plus command reference:

    which means it is only available in SQL*Plus (and probably in SQL Developer as well). It is a client side command and thus the SQL client you are using needs to support it.