Describe table_name is not working in oracle execute snap

[ppankaj88]

Hi,

I am trying to execute the sql query “describe table_name” but it is not working in oracle execute snap.

Getting an error like " Filed to execute query. Reason: ORA-00900: invalid SQL statement , Resolution: Please check sql query"

Any suggestion…?

Regards,
Pankaj

[skatpally]

describe is a SQL*Plus command not a valid SQL command

Try below

select owner, table_name, column_name, data_type, data_length, data_precision
from all_tab_columns
where table_name = ‘XXX’