Answers

Question and Answer:

  Home  Oracle Applications

⟩ What is global tempory table?

Global temporary tables are temporary table for perticular session.

Global temporary tables are two types,

1.Transaction wise temporary table

2.Session wise temporary tables.

In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.

In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.

 138 views

More Questions for you: