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.

What is sql comments?

0 Answers  

---

how do you know the version of your mysql server? : Sql dba

0 Answers  

---

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---

Is pl sql better than sql?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

define sql insert statement ? : Sql dba

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

what is column? : Sql dba

0 Answers  

---

what is unique key constraint? : Sql dba

0 Answers  

---

Which is faster union or join?

0 Answers  

---

Why do we use cursors?

0 Answers  

---