How to use temp table for Report Develpoment purpose
CREATE GLOBAL TEMPORARY TABLE tbs_stk
( primary_quantity NUMBER,
SUBINVENTORY_CODE VARCHAR2(100),
organization_id NUMBER,
ORGANIZATION_NAME VARCHAR2(1000),
ORGANIZATION_CODE VARCHAR2(100),
inventory_item_id NUMBER,
segment1 VARCHAR2(100),
description VARCHAR2(1000),
primary_uom_code VARCHAR2(10),
ITEM_TYPE VARCHAR2(50)
)
on commit delete rows
I insert data in this temp table. Now can anyone help me..How I can fetch data from this table so I can use this data to develop my report. How I use this table for report development purpose?