在Oracle上不执行'describe'命令的原因是什么?

本文介绍了在Oracle上不执行'describe'命令的原因是什么?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试在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:

• docs.oracle/database/121/SQLRF/toc.htm

describe命令的文档可以在SQL * Plus命令参考中找到:

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

• docs.oracle/database/121/SQPUG/ch_twelve001.htm#SQPUG023

这意味着它仅在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.