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!

multiplying two columns

Hira QureshiJul 28 2016 — edited Jul 29 2016

UPDATE hr.hr_leave_record SET hr.hr_leave_record.Day_count = hr.leave_type_master_list.day_count * hr.hr_leave_record.leave_day WHERE hr.leave_type_master_list.leave_type_id = hr.hr_leave_record.leave_type_id it gives me this error ORA-00904: "HR"."LEAVE_TYPE_MASTER_LIST"."LEAVE_TYPE_ID": invalid identifier need help on this

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2016

Added on Jul 28 2016

4 comments

1,591 views