PL/SQL (MOSC)

MOSC Banner

How to use temp table for Report Develpoment purpose

edited Jun 24, 2013 3:47AM in PL/SQL (MOSC) 14 commentsAnswered
I create a temp table. Code like below..

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center