Following link can provide you a good example. http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:48812 348054 Best Regards, Syed Jaffar Hussain -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mukund Sent: Wednesday, May 19, 2004 9:48 AM To: oracle-l@xxxxxxxxxxxxx Subject: Temporary table for a session. Dear All, How do we create a temporary table which expires as soon as the session ends. Regards, Mukund ________________________________________________________________________ _______________________________________________ CONFIDENTIALITY CAUTION This communication (including any accompanying documents) is intended only for the use of the addressee(s) and contains information that is PRIVILEGED AND CONFIDENTIAL. Unauthorized reading, dissemination, distribution or copying of this communication is prohibited. If you have received this communication in error, please notify us immediately by telephone (91-22) 24927039 or email at administrator@xxxxxxxxxxxxx and promptly destroy the original communication. Thank you for your cooperation. Communicating through email is not secure and capable of interception, corruption and delays. Anyone communicating with Piramyd by email accepts the risks involved and their consequences. ________________________________________________________________________ _______________________________________________ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------