wa procedure to return the month and the no'f developers
joined in each month.
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 are sql injection vulnerabilities?
Is sql procedural language?
Why is pl sql used?
What is join view in sql?
What is auto increment?
How long it takes to learn pl sql?
What is the advantage of index in sql?
What is a recursive stored procedure?
Which certification is best for sql?
What is a nested table in word?
how to use regular expression in pattern match conditions? : Sql dba
What is sql deadlock?
What are the benefits of pl/sql packages?
How to select all records from the table?
What is type and rowtype in pl sql?