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.

Give an example of Full Outer Join?

1 Answers   IBM,

---

What is primary key in db?

0 Answers  

---

How does stored procedure reduce network traffic?

0 Answers  

---

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

What is a design view?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is pl sql block in dbms?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

Explain the the update statement in sql?

0 Answers  

---