wa procedure to return the month and the no'f developers
joined in each month.
- 4 Answers
- 9266 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between rollback and rollback to statements?
What is cursor and its types?
What is a relationship and what are they?
explain what is mysql? : Sql dba
what are all the different types of indexes? : Sql dba
What is sql procedures and functions?
can sql servers linked to other servers like oracle? : Sql dba
Explain normalization and what are the advantages of it?
What are the parameter modes supported by pl/sql?
Does sql profiler affect performance?
What is foreign key and example?
What does closing a cursor do?
What is right join in sql?
What is sql injection vulnerability?
What do you mean by stored procedures?
