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...

What are the Diff B/W Cursor and REF Cursor

Answer Posted / anil

1.REF CURSOR  is basically a data type. It is normally declared as type r_cursor is REF CURSOR.
CURSOR is not a datatype.
2.REF CURSOR is dynamic , CURSOR is static
3.REF CURSOR can be passed from one procedure to other procedure but CURSOR cant be passed from one procedure to other.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between joins and union?

1194


What are triggers and its uses?

1095


how many ways to get the current time? : Sql dba

1048


Is it possible to link two groups inside a cross products after the cross products group has been created?

1069


Can we create table inside stored procedure?

1013


Does sap use sql?

1040


Is keyword pl sql?

1057


What has stored procedures in sql and how we can use it?

1126


What is a natural join sql?

1038


Does pdo prevent sql injection?

990


how would you enter characters as hex numbers? : Sql dba

1036


What are pl/sql packages?

1157


Is sql microsoft?

1105


What is sql resultset?

1039


Can we use delete in merge statement?

1099