sql中的#temp表和Oracle中的Global临时表本质上是否相同？ [英] Does #temp table in sql and Global temporary table in Oracle are same in nature?

问题描述

在sql中的#temp表和在Oracle中的全局临时表是否相同？



如果是，请解释我的详细信息如果没有请解释我将会是什么替代吗？



提前谢谢

does #temp table in sql and Global temporary table in Oracle are same in nature?

if yes please explain me detail if no please explain me what will be alternate for it?

Thanks in advance

推荐答案

RTFM ...



Oracle：

RTFM...

Oracle:

全球临时表 [ ^ ]：

这些表不驻留在系统目录中，并且不是持久的。临时表仅在声明它们的连接期间存在，并且不能在该连接之外引用。当连接关闭时，表的行将被删除，临时表的内存中描述将被删除。

These tables do not reside in the system catalogs and are not persistent. Temporary tables exist only during the connection that declared them and cannot be referenced outside of that connection. When the connection closes, the rows of the table are deleted, and the in-memory description of the temporary table is dropped.

SQL：

SQL:

临时表 [ ^ ]：

有两种类型的临时表：本地和全局。在与SQL Server实例相同的连接期间，本地临时表仅对其创建者可见，就像首次创建或引用表时一样。用户断开与SQL Server实例的连接后，将删除本地临时表。全局临时表在创建后对任何用户及任何连接都可见，并且在引用该表的所有用户与SQL Server实例断开连接时将被删除。

There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.

这篇关于sql中的#temp表和Oracle中的Global临时表本质上是否相同？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！