<div>
thanks mohammadzahid. the solution has worked, my table is working fine now.
</div>


thanks mohammadzahid. the solution has worked, my table is working fine now.

<div>
<div class="content wysiwyg-content">
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.<br />
How do i make a similar table in toad where my rows are preserved for the entire session?
</div>
</div>


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?

creating temporary session table in toad

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.