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 is the difference?

Answer Posted / hjhjnj

Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column

Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I remove all records from a table?

1023


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

990


How do I run a program in pl sql?

950


what is denormalization. : Sql dba

1038


Is primary key always clustered index?

944


What is denormalization in a database?

990


Why do we use joins in sql?

907


How many joins can you have in sql?

880


What is synonyms?

999


what are the differences between char and varchar? : Sql dba

1000


What are types of exception?

873


How do I run a query in pl sql developer?

925


Do foreign keys improve performance?

963


How to get help at the sql prompt?

1052


how can we know the number of days between two given dates using mysql? : Sql dba

990