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;

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

what is a database? : Sql dba

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

What is a natural join sql?

0 Answers  

---

What is query syntax?

0 Answers  

---

Explain what is a database?

0 Answers  

---

What is the difference between microsoft sql and mysql?

0 Answers  

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

How many types of normalization are there?

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

What are the two parts of design view?

0 Answers  

---