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 |
Write the alter statement to enable all the triggers on the t.students table.
What is sql lookup?
How many types of cursors are available in pl/sql?
What is the basic structure of an sql?
What is right join sql?
How can I delete duplicate rows?
What do you understand by pl/sql cursors?
What is time based sql injection?
Can pl sql procedure have a return statement?
What is difference between triggers and stored procedures. And advantages of SP over triggers ?
How to change sql*plus system settings?
How many commands are there in sql?