개발자인생

public class Counter extends Thread {

int a;

int b;

int sum;

Counter(int x, int y) {

a=x;

b=y;

}

public void run() {

for(int i=a; i<=b; i++) {

sum =  sum+i;

}

}

int getSum() {

return sum;

}

}

public class test01 {

public static void main(String[] args) throws InterruptedException {

Counter at = new Counter(0, 100);

System.out.println(at.isAlive());

at.start();

System.out.println(at.isAlive());

at.join();

//Thread.sleep(1);

System.out.println(at.getSum());

System.out.println(at.isAlive());

}

}

false

true

5050

false

UPDATE TAB1 A 

SET     COL1 = ( SELECT COL2 

                         FROM TAB2

                         WHERE   KEY = A.KEY );

UPDATE  /*+ BYPASS_UJVC  */

(

    SELECT  A.COL1   COL1

                , B.COL2   COL2

    FROM   TAB1 A

               , TAB2 B

    WHERE   A.KEY = B.KEY

)

SET COL1 = COL2

UPDATE  TAB1

SET        COL1 = B.COL2

FROM     TAB1 A INNER JOIN TAB2 B ON A.KEY = B.KEY