Method for finding whether there are system keywords in oracle database tables

  • 2021-12-12 06:11:59
  • OfStack

Today, in the project, I encountered an error report of "ORA-01747: user. table. column, table. column or invalid column description". After checking 1, it was caused by the poor name of the database column, and the name used the keyword of the database.


select *
from v$reserved_words
where keyword
in(
select COLUMN_NAME
from all_tab_columns
where table_name = ' Table name uppercase ' and owner=' User name uppercase '
);

ID can be ignored


Related articles: