I'm trying to get the description of a table in oracle because I need to know what foreign keys does it have and which tables they refer to. I'm using desc but all I get is "ORA-00900: invalid SQL statement" Any idea why? Thanks.
I suspect that you did not execute this command with sqlplus. Not every sql program can handle the
You can either use sqlplus or get the table definition with the following SQL command:
SELECT dbms_metadata.get_ddl (object_type, object_name, owner) FROM all_objects WHERE owner = '<owner>' AND object_name LIKE '<whatever_table>%';
This will give you the complete table definition with all column definitions.
The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.
you action should be Correct the syntax or install the Procedural Option.