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 % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?

Answer Posted / manoj

"%Type" :-It reffer one datatype which take
data type of a column in table,
Previously defined variable(Anchor type)

"%Rowtype" :-Have all type Refered May be for
Table,
Cursor,
Ref Cursor,
curor variable etc.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to add a new column to an existing table in mysql? : Sql dba

1073


who introduced sql?

1022


Is there a 64 bit version of ssms?

961


What is function and procedure in pl sql?

1046


How do you optimize a stored procedure query?

998


What is difference between sql and excel?

1094


What is the usage of when clause in trigger?

1057


what is denormalization. : Sql dba

1113


Compare sql & pl/sql

1141


Explain what is rdbms?

1036


What is a file delimiter?

1096


What are schema-level triggers?

1102


What is varchar used for?

1082


what is the difference between rownum pseudo column and row_number() function? : Sql dba

1082


What is a mutating table and a constraining table?

1115