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 difference between hql and native sql?

1235


what is sql in mysql? : Sql dba

1236


What is the unique index?

1107


How will you distinguish a global variable with a local variable in pl/sql?

1201


what is oracle database ? : Sql dba

1078


What is the syntax and use of the coalesce function?

1211


What is primary key and foreign key with example?

981


What is full join in sql?

1033


Explain what is sql*plus?

1196


What is the difference between sum and count in sql?

1034


Explain the the update statement in sql?

1099


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1489


Can we create table in function?

1017


What does 0 mean in sql?

1019


what is a database? : Sql dba

1238