CREATE TABLE TABLE1 
( 
    PKCOL1    NUMBER NOT NULL, 
    COL2      VARCHAR2 (10), 
    COL3      VARCHAR2 (10) 
)

ALTER TABLE TABLE1 
    ADD (CONSTRAINT TABLE1_PK PRIMARY KEY (PKCOL1) ENABLE VALIDATE)

CREATE TABLE TABLE2 
( 
    PKCOL1    NUMBER NOT NULL, 
    COL2      VARCHAR2 (10), 
    COL3      VARCHAR2 (10) 
)

ALTER TABLE TABLE2 
    ADD (CONSTRAINT TABLE2_PK PRIMARY KEY (PKCOL1) ENABLE VALIDATE)

BEGIN 
    FOR I IN 1 .. 100000 
    LOOP 
        INSERT INTO TABLE1 
             VALUES (i, 'A' || I, 'B' || I); 
 
        INSERT INTO TABLE2 
             VALUES (i, 'A' || I, 'B' || I); 
    END LOOP; 
 
    COMMIT; 
END; 

SELECT A.PKCOL1, A.COL2, A.COL3, 
B.PKCOL1, B.COL2, B.COL3 
FROM TABLE1 A, TABLE2 B 
WHERE    
A.PKCOL1 = 200 
AND B.PKCOL1 = 200

SELECT A.PKCOL1, A.COL2, A.COL3,  
B.PKCOL1, B.COL2, B.COL3  
FROM TABLE1 A, TABLE2 B  
WHERE     
A.PKCOL1 = 200  
AND B.PKCOL1 = A.PKCOL1