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 |
Why is nosql good?
full outer join syntax
What are Global Temporary tables
how many sql dml commands are supported by 'mysql'? : Sql dba
what is the command line end user interface - mysql? : Sql dba
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
How many disk partitions should I have?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What are sql triggers used for?
What are sql injection vulnerabilities?
Is sqlite free?
What is the Diff b/w Constraints and Trigeer
Oracle (3253)
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)