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

Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Answer Posted / kirankumar.vangeti

%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor

%TYPE is used to declare a field with the same type as that
of a specified table's column.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is table? : Sql dba

1062


What are the set operators in sql?

1069


Which function is used to return remainder in a division operator in sql?

1137


What is composite data type in pl sql?

1103


How do you update a value in sql?

1043


Why do we create stored procedures & functions in pl/sql and how are they different?

944


What is a sql select statement?

1034


How run sql*plus commands that are stored in a local file?

1059


how to enter numeric values as hex numbers? : Sql dba

1062


What is sqlcommand?

1026


Is vs as in pl sql?

984


What are different methods to trace the pl/sql code?

1117


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1127


what is recursive stored procedure? : Sql dba

984


State some properties of relational databases?

1056