I want to know the difference between A Record Type and a Table.
Answers were Sorted based on User's Feedback
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 |
Answer / s. syam sundar
table contains data
record type provides data type
Is This Answer Correct ? | 9 Yes | 4 No |
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 |
How can we store rows in PL/SQL using array?
What is offset and limit in sql?
What is a pl/sql block?
What is a clob in sql?
what is the difference between where clause and having clause? : Sql dba
how many tupples can insert in 1 second in sql
What is sql in oracle?
What is the difference between jpql and sql?
What is sql performance tuning?
What is sql partition function?
What is sqlca in powerbuilder?
Is sql database free?