Difference between PL/SQL table and Global Temporary Table. why we use Global Temporary Table without using PL/SQL Table.

nivi

• Sep 3rd, 2013

1.Global Temporary table is stored in Temporary tablespace while PL/SQL table is stored in PGA. 2.SQL operations can not be performed on pl/sql tables whereas it can be performed on GTT as any normal...

plsqlgeek

 Profile Answers by plsqlgeek Questions by plsqlgeek

• Aug 16th, 2013

PL/SQL table or associated array is a collection (data type). Where as GTT is a temp table created to store/process data for a particular session. Once you log out of the session the data is gone, not the table structure.

Answer Question  Select Best Answer

PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop.Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT statement via the CURSOR...IS statement. An implicit cursor is used for all SQL statements...

Manjunath

• Sep 1st, 2015

Hello, Given example PL/SQL program is comes under Implicit, Bcz 1. if its Explicit then cursor has to be declared in declarative part along with SELECT statement to retrieve the data from Database ...

Justo

• Jul 15th, 2015

Its an implicit cursor.

Answer Question  Select Best Answer