LoginSignup
4
2

More than 5 years have passed since last update.

CTE と INSERT INTO の組み合わせ

Posted at

正しい書き方

oracle
INSERT INTO foo
(
    bar
)
WITH buz AS (
    SELECT
        1 AS bar
    FROM DUAL
)
SELECT
    bar
FROM buz
;

間違った書き方

oracle
WITH buz AS (
    SELECT
        1 AS bar
    FROM DUAL
)
INSERT INTO foo
(
    bar
)
SELECT
    bar
FROM buz
;

発生するエラー

Oracle

ORA-00928:SELECTキーワードがありません。

4
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
4
2