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!

error msg - missing equal sign

632408Apr 6 2008 — edited Apr 6 2008

When I run this:

update hrs.pays_history
set pays_history.distribution_group
(SELECT EMPLOYEE_DISTRIBUTIONS.DISTRIBUTION_GROUP, 
EMPLOYEE_MASTER.EMPLOYEE_NO,
EMPLOYEE_DISTRIBUTIONS.ACCOUNT_ID, 
PAYS_HISTORY.DISTRIBUTION_GROUP, 
ACCOUNT_HISTORY.ACCOUNT_ID, ACCOUNT_HISTORY.CHECK_KEY *
FROM HRS.ACCOUNT_HISTORY ACCOUNT_HISTORY, 
HRS.EMPLOYEE_DISTRIBUTIONS EMPLOYEE_DISTRIBUTIONS, 
HRS.EMPLOYEE_MASTER EMPLOYEE_MASTER, 
HRS.PAYS_HISTORY PAYS_HISTORY
WHERE EMPLOYEE_DISTRIBUTIONS.EMPLOYEE_NO = EMPLOYEE_MASTER.EMPLOYEE_NO AND 
PAYS_HISTORY.EMPLOYEE_NO = EMPLOYEE_MASTER.EMPLOYEE_NO AND 
ACCOUNT_HISTORY.CHECK_KEY = PAYS_HISTORY.CHECK_KEY AND 
((PAYS_HISTORY.CONTRACT_YEAR = 2008) AND 
(ACCOUNT_HISTORY.TRANSACTION_TYPE = 'GRS')
AND EMPLOYEE_DISTRIBUTION.ACCOUNT_ID = ACCOUNT_HISTORY.ACCOUNT_ID)
[pre/]

I get the message missing equal sign, but I can see where its missing.

Thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2008
Added on Apr 6 2008
5 comments
1,495 views