Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-01730

invalid number of column names specified

Cause

The number of column names specified in a CREATE VIEW statement did not correspond to the number of columns listed in the SELECT clause. If column names were specified in a CREATE VIEW statement, exactly one name must be specified for each column or expression in the SELECT clause.


Action

Specify one view column name for each column in the SELECT clause.