Aşağıda resimde görülen şekilde col2 sütununun doldurulması gerekiyor. The output should be as shown picture below.
create table tbl (
col1 number(3),
col2 number(3));
insert into tbl values (1,null);
insert into tbl values (2,null);
insert into tbl values (3,null);
insert into tbl values (4,null);
insert into tbl values (5,null);
insert into tbl values (6,null);
insert into tbl values (7,null);
insert into tbl values (8,null);
insert into tbl values (9,null);
insert into tbl values (10,null);
insert into tbl values (11,null);
insert into tbl values (12,null);
insert into tbl values (13,null);
insert into tbl values (14,null);
insert into tbl values (15,null);
insert into tbl values (16,null);
insert into tbl values (17,null);
insert into tbl values (18,null);
insert into tbl values (19,null);
insert into tbl values (20,null);
insert into tbl values (21,null);
insert into tbl values (22,null);
insert into tbl values (23,null);
insert into tbl values (24,null);
insert into tbl values (25,null);
insert into tbl values (26,null);
insert into tbl values (27,null);
insert into tbl values (28,null);
commit;
–alternative for oracle:
/*
insert into tbl
SELECT col1, null as col2
FROM (SELECT 0 + LEVEL as col1
FROM dual
CONNECT BY LEVEL <= 28
);
COMMIT;
*/