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 |
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
What is pivot in sql?
Why use triggers in sql?
what is variable in package specification
What is minus?
What is gpt format?
What is a cursor ? Why Cursor is required ?
How you will create Toad Function?
List and explain the different types of join clauses supported in ansi-standard sql?
How to get second highest salary from a table
What are some predefined exceptions in pl/sql?
how to get help information from the server? : Sql dba
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)