wa procedure to return the month and the no'f developers
joined in each month.
Answers were Sorted based on User's Feedback
Answer / kiran
select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');
Is This Answer Correct ? | 1 Yes | 0 No |
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)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vishal narkhede
select to_char(hiredate, 'MON-RRRR'),count(1) from emp
group by to_char(hiredate, 'MON-RRRR')
Is This Answer Correct ? | 1 Yes | 1 No |
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;
Is This Answer Correct ? | 2 Yes | 6 No |
What are the different ways to optimize a sql query?
What is the relation b/w view and trigger
what are the join types in tsql? : Transact sql
Explain what is a database?
What is java sql driver?
How to set up sql*plus output format in oracle?
What is error ora-12154: tns:could not resolve the connect identifier specified?
what is the stuff function and how does it differ from the replace function? : Sql dba
what are numeric data types? : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
what is difference between decode and case function?
What is flag in sql?