Re: SQL Programmer Desc[ribe] command

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Thu, 9 Jan 2003 16:55:59 -0000
Message-ID: <AQhT9.1905$V6.2512@news.indigo.ie>

Describe is not an SQL command. It is an SQL*Plus command and so is not available unless you are using SQL*Plus (or use the TOAD equivalent ..etc.etc.etc)

You therefore get ORA-900 since Oracle does not understand describe.

Check the SQL Reference. You will not find DESCRIBE listed. "Rick" <harrisrb_at_student.gvsu.edu> wrote in message news:1d62f979.0301090835.5a34a596_at_posting.google.com...
> Anyone familiar with BMC Software SQL Programmer, how do I issue the
> Describe (desc) command from a free sql window? One would think it
> was as simple as :
> desc username.databaseobject -or- describe username.databaseobject
> but both return "ORA-00900: invalid SQL statement"
Received on Thu Jan 09 2003 - 10:55:59 CST