On the basis of name, visibility and availability, Temporary USP, further classified as -
i) Local (#, to current user connection, auto deleted when connection is closed)
ii) Global (##, to any user after creation, auto deleted when the last session using proc ends)
[More]