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!

Calculate the sum of 2 columns into total column .

2621922Feb 28 2014 — edited Feb 28 2014

hello everyone .

I have a question I hope you could help

I'm using oracle 10g form I made table for student info there is 5 columns ( HomeWorks , Project , Midterm1, Midterm2 ,FinalExam), I need to calculate these marks and put it into ( Total ) column using oracle form . How to ? .

another thing is it possible for me to restrict the user so he can not enter more than 10 marks for homeworks and not more than 15 marks for project ,,,etc ?

I hope you could answer me I'm really really really really grateful I have searched online but no real solution found especially for the second part of the question . shall I change the varchar2 to numbers?

Thank you

This post has been answered by AnnEdmund on Feb 28 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2014

Added on Feb 28 2014

#pl-sql, #plsql

26 comments

16,535 views