Oracle:如果不存在行，如何插入 [英] Oracle: how to INSERT if a row doesn't exist

问题描述

在PL/SQL(oracle)中，如果不存在，则最简单的插入行的方法是什么?

What is the easiest way to INSERT a row if it doesn't exist, in PL/SQL (oracle)?

我想要类似的东西:

IF NOT EXISTS (SELECT * FROM table WHERE name = 'jonny') THEN
  INSERT INTO table VALUES ("jonny", null);
END IF;

但是它不起作用.

注意:此表有2个字段，例如名称和年龄.但是只有 name 是PK.

Note: this table has 2 fields, say, name and age. But only name is PK.

推荐答案

INSERT INTO table
SELECT 'jonny', NULL
  FROM dual -- Not Oracle? No need for dual, drop that line
 WHERE NOT EXISTS (SELECT NULL -- canonical way, but you can select
                               -- anything as EXISTS only checks existence
                     FROM table
                    WHERE name = 'jonny'
                  )

这篇关于Oracle:如果不存在行，如何插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！