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 the methods using performance tunning in sql and pl/sql

2 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

Can we insert data in view?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

What is a mutating table and a constraining table?

0 Answers  

---

What is a cursor for loop ?

4 Answers  

---

What are analytical functions in sql?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

What is %type in sql?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

what is the sql query to display current date? : Sql dba

1 Answers  

---