local and global.
Local temporary tables are created using a single pound (#) sign and are visible to a single connection and automatically dropped when that connection ends.
Global temporary tables are created using a double pound (##) sign and are visible across multiple connections and users and are automatically dropped when all SQL sessions stop referencing the global temporary table.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment