How to solve Oracle Database Error 1730 (ora-01730)

Oracle Error Code
   ora-01730

Description
   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 are specified in a CREATE VIEW statement, exactly one name must be specified for each column or expression in the SELECT clause.
How to Solve
   Specify one view column name for each column in the SELECT clause.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-01630    ORA-01631    ORA-01632    ORA-01730    ORA-01731    ORA-01732    ORA-01733  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares