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 you see all indexes defined for a table? : Sql dba
What does partition by mean in sql?
what are the authentication modes in sql server? : Sql dba
What are all different types of collation sensitivity?
Which operator is used in query for pattern matching?
What is not equal in sql?
What is nvl?
What is a natural join?
How do you create a db file?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
How can a function retun more than one value in oracle with proper example?
What are the dml statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)