SQL> set serveroutput on SQL> SQL> begin 2 for i in 0..9 loop 3 for j in 0..9 loop 4 for k in 0..9 loop 5 if (i+j+k)*11=i*100+j+10+k then 6 dbms_output.put_line('AA='||i||i||',BB='||j||j||',CC='||k||k||';'); 7 end if; 8 end loop; 9 end loop; 10 end loop; 11 end; 12 /
AA=00,BB=00,CC=11; AA=00,BB=11,CC=00;
PL/SQL procedure successfully completed
SQL>
写错一个地方. SQL> begin 2 for i in 0..9 loop 3 for j in 0..9 loop 4 for k in 0..9 loop 5 if (i+j+k)*11=i*100+j*10+k then 6 dbms_output.put_line('AA='||i||i||',BB='||j||j||',CC='||k||k||';'); 7 end if; 8 end loop; 9 end loop; 10 end loop; 11 end; 12 /
AA=00,BB=00,CC=00; AA=11,BB=99,CC=88;
PL/SQL procedure successfully completed
SQL>
SQL> begin 2 for i in 0..9 loop 3 for j in 0..9 loop 4 for k in 0..9 loop 5 if (i+j+k)*11=i*100+j*10+k then 6 dbms_output.put_line(i||i||'+'||j||j||'+'||k||k||'='||i||j||k||';'); 7 end if; 8 end loop; 9 end loop; 10 end loop; 11 end; 12 /
SQL>
SQL> begin
2 for i in 0..9 loop
3 for j in 0..9 loop
4 for k in 0..9 loop
5 if (i+j+k)*11=i*100+j+10+k then
6 dbms_output.put_line('AA='||i||i||',BB='||j||j||',CC='||k||k||';');
7 end if;
8 end loop;
9 end loop;
10 end loop;
11 end;
12 /
AA=00,BB=00,CC=11;
AA=00,BB=11,CC=00;
PL/SQL procedure successfully completed
SQL>
SQL> begin
2 for i in 0..9 loop
3 for j in 0..9 loop
4 for k in 0..9 loop
5 if (i+j+k)*11=i*100+j*10+k then
6 dbms_output.put_line('AA='||i||i||',BB='||j||j||',CC='||k||k||';');
7 end if;
8 end loop;
9 end loop;
10 end loop;
11 end;
12 /
AA=00,BB=00,CC=00;
AA=11,BB=99,CC=88;
PL/SQL procedure successfully completed
SQL>
2 for i in 0..9 loop
3 for j in 0..9 loop
4 for k in 0..9 loop
5 if (i+j+k)*11=i*100+j*10+k then
6 dbms_output.put_line(i||i||'+'||j||j||'+'||k||k||'='||i||j||k||';');
7 end if;
8 end loop;
9 end loop;
10 end loop;
11 end;
12 /
00+00+00=000;
11+99+88=198;
PL/SQL procedure successfully completed
SQL>