create or replace procedure procdure_name cursor c1 is select count(*),mo

wa procedure to return the month and the no'f developers
joined in each month.

Question Posted / narenkumar reddy

4 Answers
10157 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

Please Help Members By Posting Answers For Below Questions

What are the two types of exceptions.

1171

How do I start pl sql?

948

Explain the difference between sql and mysql.

1062

What is a crud api?

954

Can primary key be changed?

906

What is spool?

1054

How can I see all tables in sql?

1077

What is pl sql block in dbms?

1005

What are the two types of periodical indexes?

940

explain the difference between myisam static and myisam dynamic. : Sql dba

944

What is sql character function?

1086

How can I make sql query run faster?

1016

Is hadoop a nosql?

1006

Can we insert data into materialized view?

945

Does pl sql work in mysql?

982