creating temporary session table in toad
Posted on 2007-11-30
I have been using oracle sql developer till now, but recently shifted to toad. Here when i am creating a temporary table for the session, the only available option in toad is 'TEMPORARY GLOBAL'. when i use this option, the data in my table is only there for a transaction and not for the entire session. as against this in sql developer there was a option of temporary(session) in which the table preserved rows till the whole session.
How do i make a similar table in toad where my rows are preserved for the entire session?