Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.