插入到具有多个选择语句的私有临时表中

Question

我有一个私有临时表，我想将来自不同表的多个选择语句的记录插入到表中。

CREATE PRIVATE TEMPORARY TABLE ora$ptt_my_temp_table (
ID NUMBER,
name VARCHAR(20),
docType VARCHAR(20)
)
INSERT INTO ora$ptt_my_temp_table(ID, name, docType)
(SELECT ID FROM Case WHERE userCase = 'test'),
(SELECT userID FROM CASE where ID = '3'),
(SELECT title from Version WhERE ID = '3')

我以为会是这样，但我缺少表达式或有时值太多。我不确定出了什么问题。抱歉不习惯Oracle SQL，已经使用SQL Server一段时间了

Answer 1

您可以使用select . . . from dual：

INSERT INTO ora$ptt_my_temp_table (ID, name, docType)
SELECT (SELECT ID FROM Case WHERE userCase = 'test'),
(SELECT userID FROM CASE where ID = '3'),
(SELECT title from Version WhERE ID = '3')
FROM dual;