在Oracle上不执行'describe'命令的原因是什么? [英] What is the reason for not working of 'describe' command on oracle?
问题描述
我正在尝试在oracle上运行'describe table_name'命令.我正在使用dbeaver访问oracle.但是，当我运行命令时，它显示SQLException和错误消息无效的sql语句".我该如何执行操作?
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?
推荐答案
describe不是SQL语句，否则将在SQL语言参考中进行记录:
describe is not a SQL statement, otherwise it would have been documented in the SQL language reference:
describe命令的文档可以在SQL * Plus命令参考中找到:
The documentation for the describe command can be found in the SQL*Plus command reference:
这意味着它仅在SQL * Plus(可能还有SQL Developer)中可用.这是一个客户端命令，因此您正在使用的SQL客户端需要支持它.
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.
这篇关于在Oracle上不执行'describe'命令的原因是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
