Oracle数据表中添加记录的方法:
1、insert into n select id from m;
2、insert into n values(12);
3、create table cc(id int,sex char,age int);
insert into cc(id,sex,age)
select 1,0,9 from dual union
select 2,0,19 from dual union
select 3,0,78 from dual;
4、create table m as select * from n where rownum<10;–插入9行
Oracle中插入记录的方法
最新推荐文章于 2021-04-07 07:17:09 发布