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

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 24th, 2017

Global Temporary Table(GTT): --------------------------------------- --> GTT operation perform in-memory(RAM) so reading data from GTT is a "Logical Read" -> hence its faster. --> GTT are of 2 type...

vanishavadlya

 Profile Answers by vanishavadlya Questions by vanishavadlya

• Oct 24th, 2009

The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for t...

Answer Question  Select Best Answer

What is Force View. Why Oracle Give Facility to create force view? What is the use of force View

sonam kanungo

• Oct 15th, 2011

As per my knowledge when view is created without base table.then the view is called as forced view.

in this type of view is created with compilation error.

mohan

• Oct 14th, 2011

If we create a view without having base table, that view called as forced view. it will create with compile error. it will be in invalid till base table create.

Answer Question  Select Best Answer

Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P

Himansu

• Nov 6th, 2012

In procedure,Function there are three types of parameter is there. eg-IN, OUT, INOUT. IN parameter is call by reference and OUT & INOUT are call by value. Always call by reference is faster than call ...

Saket

• Apr 3rd, 2012

Pass by reference: "IN" Case
Pass by value : "Out" or "IN OUT" Case which have the overhead of copying the value to new procedure parameter.
In order to make to Pass by reference we will use NOCOPY
Pass by reference: "OUT NOCOPY" or "IN OUT NOCOPY" which deals which the actual reference value.

Answer Question  Select Best Answer