oracle 插入 insert into with select

最新推荐文章于 2022-10-13 14:48:52 发布

最新推荐文章于 2022-10-13 14:48:52 发布 · 2.6k 阅读

文章标签：

#Oracle #C #C++ #C#

oracle 专栏收录该内容

60 篇文章

订阅专栏

本文演示了如何在SQL中创建表、插入数据并利用序列生成唯一标识符。通过示例代码介绍了表的基本管理和序列值的正确使用方法。

部署运行你感兴趣的模型镜像

[code]set feedback off;
set pagesize 0;

create table foo (a number, b varchar(10), c varchar(10));

insert into foo values ( 15, 'abc','def' );
insert into foo values (998, 'max','min' );
insert into foo values ( 7, 'bla','bla' );
insert into foo values (632, 'now','then');

insert into foo
(a,b,c)
(select AA,
BB,
CC
from
(select max(a) +1 AA from foo),
(select 'new' BB,
'old' CC from dual));

select * from foo where a = (select max(a) from foo);

drop table foo;[/code]

注意，当需要序列值时，不能放在子查询中
[code]INSERT INTO T_A
(id,
goodsA_id,
goodsB_id,
goodsC_id,
num,
money,
dateA_id,
dateB_id,
create_date)
(SELECT test1_SEQUENCE.NEXTVAL,
goodsA_id,
goodsB_id,
goodsC_id,
num,
money,
dateA_id,
dateB_id,
SYSDATE
FROM (SELECT goodsA_id,
goodsB_id,
goodsC_id,
num,
33 money
FROM goods_info),
(SELECT id dateA_id,
period dateB_id
FROM date_x
WHERE flagA = 'Y'))[/code]

您可能感兴趣的与本文相关的镜像