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 personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.