oracle - Oracle 是否有等效于 SQL Server 的表变量？

Question

在 SQL Server 中，您可以声明一个表变量 ( DECLARE @table TABLE )，该变量在脚本运行时生成，然后从内存中删除。

甲骨文有类似的功能吗？还是我坚持 CREATE/DROP分割我的硬盘的语句？

Answer 1

是的。

Declare TABLE TYPE variables in a PL/SQL declare block. Table variables are also known as index-by table or array. The table variable contains one column which must be a scalar or record datatype plus a primary key of type BINARY_INTEGER. Syntax:

DECLARE TYPE type_name IS TABLE OF (column_type | variable%TYPE | table.column%TYPE [NOT NULL] INDEX BY BINARY INTEGER;

-- Then to declare a TABLE variable of this type: variable_name type_name;

-- Assigning values to a TABLE variable: variable_name(n).field_name := 'some text'; -- Where 'n' is the index value

引用: http://www.iselfschooling.com/syntax/OraclePLSQLSyntax.htm

您可能还想看看 Global Temporary Tables