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

Answer / s. syam sundar

table contains data

record type provides data type

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.

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

How many databases can sql express handle?

0 Answers  

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

How do you change a value in sql?

0 Answers  

---

What is data types in sql?

0 Answers  

---

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

what is blob? : Sql dba

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---

What are the types of SQL Statement?

3 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

What is the primary key?

0 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---