SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Local temporary table

SamFisherApr 30 2015 — edited Apr 30 2015

Hello All,

Oracle version: 11g.

I know how the global temporary table works in Oracle. But I never heard about local temporary tables. I cam e across and I tried to create one by googling. But couldn't create.

The syntax I used is,

DECLARE LOCAL TEMPORARY TABLE test_sk5 (col1 number, col2 NUMBER);

Can you please shed some light about local temporary tables.

Thx & Regards,

Shan.

This post has been answered by John Stegeman on Apr 30 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2015

Added on Apr 30 2015

4 comments

6,878 views