basic addition problem

Dev Shed Forums Sponsor:

July 18th, 2005, 07:45 PM

dancesport_warr

Contributing User

Join Date: Aug 2004

Posts: 130

Time spent in forums: 1 Day 14 h 14 m 36 sec
Reputation Power: 5

basic addition problem

Hello,

I seem to be having a problem with something very simple. The code is this:

Code:

declare
	empNum number := 7934;
	cursor getSal is select sal from emp;
	salary number(7,2);
	avg number(7,2) := 0;
	amtOfEmps number := 0;
	diff number(7,2);
begin
	--1)find out average salary of employee's dept
	open getSal;
	loop
		fetch getSal into salary;
		exit when getSal%notfound;
		avg := avg + salary;
		amtOfEmps := amtOfEmps + 1;
	end loop;
	close getSal;
end;

I have an error for this line:

Code:

avg := avg + salary;

The error is:

Quote:

Encountered the symbol "+" when expecting one of the following:
(

I have no idea why this comes up

If anyone spots an error I would greatly appreciate if u could point it out. Thanks a lot

July 20th, 2005, 11:03 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,917

Time spent in forums: 2 Months 3 Weeks 3 Days 14 h 31 m 53 sec
Reputation Power: 279

avg is a reserved word, it stands for the function average.
If you need the average salary of a department you can do something like:

Table: |dept|emp|salary|

select dept, avg(salary) from table group by dept

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

July 25th, 2005, 05:30 AM

deepa.es

Registered User

Join Date: Jul 2005

Posts: 2

Time spent in forums: 1 h 51 m 17 sec
Reputation Power: 0

Quote:

Originally Posted by dancesport_warr

Hello,

I seem to be having a problem with something very simple. The code is this:

Code:

declare
	empNum number := 7934;
	cursor getSal is select sal from emp;
	salary number(7,2);
	avg number(7,2) := 0;
	amtOfEmps number := 0;
	diff number(7,2);
begin
	--1)find out average salary of employee's dept
	open getSal;
	loop
		fetch getSal into salary;
		exit when getSal%notfound;
		avg := avg + salary;
		amtOfEmps := amtOfEmps + 1;
	end loop;
	close getSal;
end;

I have an error for this line:

Code:

avg := avg + salary;

The error is:

I have no idea why this comes up

If anyone spots an error I would greatly appreciate if u could point it out. Thanks a lot

u have used oracle keyword "avg: thats y it is showing an error

July 25th, 2005, 05:30 AM

deepa.es

Registered User

Join Date: Jul 2005

Posts: 2

Time spent in forums: 1 h 51 m 17 sec
Reputation Power: 0

Quote:

Originally Posted by dancesport_warr

Hello,

I seem to be having a problem with something very simple. The code is this:

Code:

declare
	empNum number := 7934;
	cursor getSal is select sal from emp;
	salary number(7,2);
	avg number(7,2) := 0;
	amtOfEmps number := 0;
	diff number(7,2);
begin
	--1)find out average salary of employee's dept
	open getSal;
	loop
		fetch getSal into salary;
		exit when getSal%notfound;
		avg := avg + salary;
		amtOfEmps := amtOfEmps + 1;
	end loop;
	close getSal;
end;

I have an error for this line:

Code:

avg := avg + salary;

The error is:

I have no idea why this comes up

If anyone spots an error I would greatly appreciate if u could point it out. Thanks a lot

u have used oracle keyword "avg" thats y it is showing an error

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: