Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column Not Allowed HERE

69750c0b-5eb8-40e7-aa4c-dc1910572334Mar 4 2018 — edited Mar 5 2018

Can anyone tell whats wrong with the following?

pastedImage_0.png

According to https://docs.oracle.com/cd/B10500_01/server.920/a96525/e900.htm

The error I am getting is A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement. But I don't see any column name specified in the VALUES.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2018
Added on Mar 4 2018
7 comments
1,583 views