I have just started using PL/SQL.

Is it possible to create temporary tables on the fly that can be filled with data and used to perform other SQL statements. Also, many users will be running the stored procedure at the same time so the tables need to be part of the user's private session.

I came across some documentation that PL/SQL can not create tables. How do you get around this?

Any help would be appreciated.