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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

create a procedure for count the employee in department wise

883415Mar 5 2012 — edited Mar 5 2012

hi to all i am new to oracle

i have SQL code to count the employee in department wise.some one help me how to create procedure for the same

select department_id,count(*)
from employees
group by department_id

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2012

Added on Mar 5 2012

2 comments

690 views