Oracle database error code ORA-01730 – invalid number of column names specified

Oracle Database Error Code ORA-1730 Description :
invalid number of column names specified
Error 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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»