Extending Global Temporary Tables
You might not need to extend the Global Temporary tables as the out-of-the-box table itself contains multiple flexible columns. Each GTT and RM table contains:
- 15 columns of type VARCHAR2 (4000)
- 4 columns to support DATE fields. The data type is VARCHAR2(8)
- 2 clob columns
You can fill these columns by using user exits.
Parent topic: Database Layer