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 limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

What is normalization sql?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

How does a trigger work?

0 Answers  

---

What operators deal with null?

0 Answers  

---

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

Explain what is a subquery ?

0 Answers  

---

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

---

Can triggers stop a dml statement from executing on a table?

0 Answers  

---

Which version of sql do I have?

0 Answers  

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---