Answer Posted / subbu

Global temporary tables belongs to that session only

create global temporary table test_gbl
( l_number_no number,
l_char_vc varchar2(100)
) [on commit delete rows]

ON COMMIT DELETE ROWS:- It's a default one
If any commit will issued that total data of a table will
losses. But table is exit

To overcome this we have option
ON COMMIT PRESERVE ROWS:-
means, If commit will issue the data of a table willn't loss
up to end of the session. Is session ends the data will losses.

Regards
Subbu

What are data types in pl sql?

1199

---

Is inner join same as self join?

1168

---

What is the difference between having and a where in sql?

1152

---

what are the advantages and disadvantages of views in a database? : Sql dba

1074

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1292

---

What are different types of queries in sql?

1177

---

What are the datatypes available in pl/sql ?

1155

---

Is merge a dml statement?

1032

---

What is type and rowtype in pl sql?

1057

---

how to add a new column to an existing table in mysql? : Sql dba

1114

---

Which kind of parameters cannot have a default value in pl sql?

1212

---

How can we solve sql error: ora-00904: invalid identifier?

1295

---

What is string join?

1025

---

what is the difference between blob and text? : Sql dba

1064

---

Explain how to use transactions efficiently : transact sql

1017

---