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 is the process of copying data from table a to table b?
What is flag in sql?
What are the types of variables use in pl sql?
what is 'mysqldump'? : Sql dba
How bulk collect improves performance?
How do I quit sql?
What is multiple columns?
What is the use of double ampersand (&&) in sql queries? Give an example
What does a pl/sql package consist of?
Why do we use sqlite?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What does the acronym acid stand for in database management?
Is not equal in sql?
Is sql developer case sensitive?
What is delete command in sql?