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 is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

How to execute a stored procedure?

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

What are pl/sql cursors?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What is information schema in sql?

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---

Why procedure is used in sql?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

---

how to insert the records in particular position

1 Answers  

---