Forum Discussion

ppankaj88's avatar
ppankaj88
New Contributor II
6 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 statem...
skatpally's avatar
skatpally
Former Employee
6 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’