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 is the process of copying data from table a to table b?

1138


What is flag in sql?

1099


What are the types of variables use in pl sql?

1093


what is 'mysqldump'? : Sql dba

1169


How bulk collect improves performance?

1055


How do I quit sql?

1008


What is multiple columns?

1120


What is the use of double ampersand (&&) in sql queries? Give an example

1190


What does a pl/sql package consist of?

1019


Why do we use sqlite?

1029


Can you select everything, but 1 or 2 fields, without writer's cramp?

1041


What does the acronym acid stand for in database management?

1091


Is not equal in sql?

1064


Is sql developer case sensitive?

1048


What is delete command in sql?

1174