Not really. However, starting with Oracle8i you can use something called GLOBAL Temporary Table. You can specify whether to preserve or delete the rows on commit.
The advantage is that the data in GLOBAL Temporary Table is available only during the session and you can even...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
index the global temporary table and sort it using normal select statements.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.