Unlikely you really need to do this. Oracle isn't Sybase and readers don't
block writers and writers don't block readers. Views in Oracle are not bad
things. If you really really really feel you just gotta have this look in
the docs for global temporary table. If you have the correct version. But
alas you don't mention what version of Oracle.
Jim
"Wayne R Happ" <waynehapp_at_earthlink.net> wrote in message
news:7eb58012.0211211105.23a1268f_at_posting.google.com...
> Does Oracle has equivalent functionality to Sybase's temporary tables in
tempdb?
>
> Something like Sybase's #table i.e.
>
> Example Sybase SQL
>
> create #table (one char(10))
>
> Wayne
Received on Thu Nov 21 2002 - 16:42:32 CST
