Answer / kiran

select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');

Answer / arrry.net

It's simple
No need to use Cursor for that

select Month(Joindate)as MONTH,count(*) as empCount from dbo.tblEmployee
Group by Month(Joindate)

Answer / vishal narkhede

select to_char(hiredate, 'MON-RRRR'),count(1) from emp
group by to_char(hiredate, 'MON-RRRR')

Answer / narenkumar reddy

create or replace procedure
procdure_name
cursor c1 is select count(*),month from table
is
begin
for i in c1
loop
dbms_output.put_line(i.count(*)||i.month)
end loop;
end;

What are aggregate functions in sql?

0 Answers  

---

How many types of literals are available in pl sql?

0 Answers  

---

What is sql comments?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

What is composite primary key in sql?

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

how to convert character strings to dates? : Sql dba

0 Answers  

---