Answer / shwetha n k

GLOBAL TEMPORARY TABLES in Oracle are tables that are created distinct within the Oracle sessions.
Oracle support two types of temporary tables.
•Global Temporary Tables : Available since Oracle 8i and subject of this article.
•Private Temporary Tables : Available since Oracle 18c. Discussed here.
you can create GTT table with on commit delete rows or on commit preserved rows.

Who developed sql?

0 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

Explain what is a subquery ?

0 Answers  

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What is a behavioral trigger?

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

how to saw triggers output in pl/sql database?

1 Answers  

---

What is index example?

0 Answers  

---

what is the boundary line in varrays?

1 Answers   HCL,

---