Forum Discussion

ppankaj88's avatar
ppankaj88
New Contributor II
5 years ago

Describe table_name is not working in oracle execute snap

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

1 Reply

  • skatpally's avatar
    skatpally
    Former Employee
    5 years ago

    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’