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 the conventional and direct path loader? : aql loader

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

How long will it take to learn pl sql?

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

What are sql objects?

0 Answers  

---

Can we join two tables without common column?

0 Answers  

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---