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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

I want to know the difference between A Record Type and a Table.

Question Posted / akshay

Answers were Sorted based on User's Feedback



I want to know the difference between A Record Type and a Table...

Answer / devi

table is a object where as a recordtype is a user defined
datatype .a table can store data from one table at a time
where as different variable or column declared with
sametype can stores data from multiple table

Is This Answer Correct ?    16 Yes 1 No

I want to know the difference between A Record Type and a Table...

Answer / s. syam sundar

table contains data

record type provides data type

Is This Answer Correct ?    9 Yes 4 No

I want to know the difference between A Record Type and a Table...

Answer / ajitabh tiwari

A record will have multiple columns in it which can store one record..
A table can store multiple rows of single columns or multiple rows of records
Record:
u have to declare the type of the record which datatype cols it stores
means grouping different datatype cols in one record type
so now u can store the values according to it.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

What information is needed to connect sql*plus an oracle server?

0 Answers  

How to disable a trigger name update_salary?

0 Answers  

What is the maximum number of triggers,can apply to a single table?

2 Answers  

Can you rollback after commit?

0 Answers  

What are the components of a PL/SQL block ?

3 Answers  

What are the Restrictions on Cursor Variables?

2 Answers  

how to start mysql server? : Sql dba

0 Answers  

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

Difference between truncate, delete and drop commands?

0 Answers  

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

For more SQL PLSQL Interview Questions Click Here
Categories