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 |
what is check constraint? : Sql dba
What do you understand by exception handling in pl/sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are the two different parts of the pl/sql packages?
What is sql resultset?
How do you modify a table in sql?
What is the difference between function and procedure in pl/sql?
what is data integrity
How to add a column ‘salary’ to a table employee_details?
What is a pragma statement?
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
What is microsoft t sql?
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)