Answer Posted / vijay

1.global temporary table is a schema object
2.global temporary table record is store in session level but not store in database
3.global temporary table structure of the table is store in database but record not store in database
4.global temporary table record not shown one session to another session level
5.it is used reporting purpose temporarily record saved in session level
Two types
1.on commit delete rows( all records deleted structure of table only shown)
2.on commit preserve rows(record saved in session level (once login &logout record gone)
create global temporary table table_name on commit preserve rows as select * from employees;

What are the types of records?

1033

---

What are the sql commands?

1222

---

Does sqlite need a server?

1094

---

What is the usage of when clause in trigger?

1087

---

How is sql used in oracle?

1035

---

explain advantages of innodb over myisam. : Sql dba

1174

---

What is sql in java?

1131

---

How do you sort in sql?

1062

---

What is Histogram?

1607

---

tell us something about heap tables. : Sql dba

1133

---

What is the difference between Union and Union all. Which is faster.

1436

---

What are the built in functions of sql?

1089

---

How does an execution block start and end in pl sql?

993

---

what are the properties and different types of sub-queries? : Sql dba

1072

---

what is a cursor? : Sql dba

1059

---