Is it possible to create local temporary table..?
We create Global Temporary table by the syntax
Create Global Temporay table ....
This Global Temp table, people at differnet session can work. One session can not see the data of another session.
But I want to create the table and drop it after it is used. It has to be done inside a stored procedure.
Is it possible to create local temporarytable...? If it is possible all the people can create the local temp table at their own seesion with same name and drop the table after it is used..
Re: Is it possible to create local temporary table..?
That might be how you do it in other RDBMS, but what benefit do you get from that? (It sounds to me like a case of "pissing against the wind" as the French would say.)
Originally posted by skdas
But I want to create the table and drop it after it is used
If you really must and all this is happening in the same schema, try creating a table with a name derived from the Audit SID (see SESSIONID in SYS_CONTEXT) - that should be unique.