Re: Creating Temporary Tables in Oracle

I dont believe this to be true.

1. Oracle doesn't support "Temporary" tables.
2. When a table is created in Oracle there is an implicit commit.

You could use a cursor or a PL table - no one else could access that information but you.

Michael.

Jerry Gitomer wrote:
>
> Hi,
>
> When you create a table in an Oracle session it is not visible to any
> other user, including other sessions for the same user, until a commit is
> done. If you can avoid doing an implicit commit until you are ready to drop
> the table (and of course don't do an explicit commit) you will not have a
> problem.
>
> If a commit is done there is no way of preventing anyone logged in with the
> same username from finding out the name of the table and, once they know the
> name, insert, delete, update, or even drop the table as well as select ing
> from it.
>
> Picture the following scenario. You create a table giving it an esoteric
> name unknown to your co-workers. Joe the practical joker logs in using the
> same username and does a:
>
> SELECT TABLE_NAME FROM USER_TABLES;
>
> Joe sees a strange new table and goes exploring ....
>
> regards
>
> Jerry
>
> sumanm_at_my-dejanews.com wrote in message <7188li$ogo$1_at_nnrp1.dejanews.com>...
> >How can I create temporary tables in Oracle ?
> >I know that SQL Server supports temporary tables.
> >Basically, I need to create a temporary table containing
> >a subset of the data from another table. Then I want
> >to update some rows in that temporary table,
> >use it and later drop it.
> >
> >I don't want anyone else who has logged on using the
> >same userid/pwd to see my temporary table.
> >
> >How do I achieve that ?
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 29 1998 - 10:57:02 CST