Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are sql injection vulnerabilities?

912


Is sql procedural language?

921


Why is pl sql used?

939


What is join view in sql?

899


What is auto increment?

936


How long it takes to learn pl sql?

952


What is the advantage of index in sql?

917


What is a recursive stored procedure?

1098


Which certification is best for sql?

940


What is a nested table in word?

911


how to use regular expression in pattern match conditions? : Sql dba

966


What is sql deadlock?

1050


What are the benefits of pl/sql packages?

1034


How to select all records from the table?

1069


What is type and rowtype in pl sql?

968