Oracle insert into and update
IDNAMEAGEGENDERBB
11, 3, 17, male 16
22 Li Si 18 male 16
33 Wang Wu 19 male 16
44 Zhao Liu20 female 16
55 Li Jian 17 male 16
66 Wang Jian 39 male 16
77 Sun Jian 17 female 16
88 Sun Qian 13 male 16
99 Zhang Jing 32 female 16
1010 Wang 62 female 16
1111 Lee Jin-kee 13 Women 16
121zang 317 male 16
132 Li 2 4 18 male 16
143 king 2 5 19 men 16
154 Zhao 266 20 female 16
165 Li Erjian 17 male 16
Source table
Execute statement
Declare
C varchar2 (10)
Begin
For i in 0.. 16 loop
CRAV.
Dbms_output.put_line (c)
Insert into byp_1 (bb) values (c)
-- update byp_1 set bb=c where bb is not null
End loop
End
IDNAMEAGEGENDERBB
11, 3, 17, male 16
22 Li Si18 male 16
33 Wang Wu 19 male 16
44 Zhao Liu20 female 16
55 Li Jian 17 male 16
66 Wang Jian 39 male 16
77 Sun Jian 17 female 16
88 Sun Qian 13 male 16
99 Zhang Jing 32 female 16
1010 Wang 62 female 16
1111 Lee Jin-kee 13 Women 16
121zang 317 male 16
132 Li 2 4 18 male 16
143 king 2 5 19 men 16
154 Zhao 266 20 female 16
165 Li Erjian 17 male 16
one hundred and seventy
one hundred and eighty one
one hundred and ninety two
two hundred and three
two hundred and fourteen
two hundred and twenty five
two hundred and thirty six
two hundred and forty seven
two hundred and fifty eight
two hundred and sixty nine
2710
2811
2912
3013
3114
3215
3316
Then execute the statement against the source table
IDNAMEAGEGENDERBB
11, 3, 17, male 16
22 Li Si18 male 16
33 Wang Wu 19 male 16
44 Zhao Liu20 female 16
55 Li Jian 17 male 16
66 Wang Jian 39 male 16
77 Sun Jian 17 female 16
88 Sun Qian 13 male 16
99 Zhang Jing 32 female 16
1010 Wang 62 female 16
1111 Lee Jin-kee 13 Women 16
121zang 317 male 16
132 Li 2 4 18 male 16
143 king 2 5 19 men 16
154 Zhao 266 20 female 16
165 Li Erjian 17 male 16
1716
1816
1916
2016
2116
2216
2316
2416
2516
2616
2716
2816
2916
3016
3116
3216
3316
What's going on? Pray for the great god
