What is Global temporary table in oracle? and what are the benefits of it?

What is Global temporary table in oracle? and what are the benefits of it?

GLOBAL TEMPORARY TABLE is used to store temporary data in scenarios where complex calculation is involved. The data in this table is session specific. This means that the data in temporary table cannot be shared with other sessions and is valid only until session is active. It is most useful when the table structure of an application is not known or the data in the temporary table is needed only while using the application.
What is Pragma Init Exception in oracle?
Pragma init exception is used to associate a user defined exception with an error number and a custom message....
Disadvantages of trigger in oracle.
Triggers can execute every time some field in database is updated. If a field is likely to be updated often, it is a system overhead.......
What is a NOCOPY parameter in oracle?
Apart from IN, OUT, IN OUT parameters, oracle 8i offers another parameter called NOCOPY.....
Post your comment