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 are the different tcl commands in sql?

1160


What is the difference between instead of trigger and after trigger?

994


What is case function?

1028


How can I see all tables in sql?

1059


What are field types?

985


Can we use ddl statements in stored procedure?

1136


Why use stored procedures?

1072


What are the methods of filing?

926


Why join is faster than subquery?

1102


Is it possible to create the following trigger: before or after update trigger for each row?

1276


What are sql functions? Describe the different types of sql functions?

1132


Why do we use function in pl sql?

1052


how to enter characters as hex numbers? : Sql dba

1031


What is the maximum number of rows in sql table?

1017


What is pl sql commands?

1034