Skip to Main Content
Forums

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!

Ora-00913: too many values

3226374Jun 1 2016 — edited Jun 1 2016

hello please how can  correct my query?

im using oracle 10g

i want to select "rating" from RATINGAVG table,

and i have foreign key "documentId" in  RATINGAVG too.

SELECT

d.DOCUMENT_ID,

(select DOCUMENTID, Round(avg(rating))

from RATINGAVG

where DOCUMENTID=d.DOCUMENT_ID

)

from Documents  d


when i run this query i got :

Ora-00913: too many values
This post has been answered by Vysakh Suresh - 3035408 on Jun 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2016
Added on Jun 1 2016
2 comments
765 views