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

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

Can we create clustered index without primary key?

0 Answers  


what is error ora-03113: end-of-file on communication channel?

0 Answers  


What is a system versioned table?

0 Answers  


what are date and time functions in mysql? : Sql dba

0 Answers  


How many types of cursors supported in pl/sql?

0 Answers  






What are the possible values for the boolean data field?

0 Answers  


What is sql trigger example?

0 Answers  


How sql query is executed?

0 Answers  


What does trigger mean in psychology?

0 Answers  


what is julian date in oracle

2 Answers  


How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,


How do I view a sql trace file?

0 Answers  


Categories