create table t1 (id number)Table created.
create table t2 (id number, t1_id number)Table created.
insert into t1 (id) values (1)1 row(s) inserted.
insert into t1 (id) values (2)1 row(s) inserted.
insert into t2 (id, t1_id) values (1,1)1 row(s) inserted.
insert into t2 (id, t1_id) values (2,1)1 row(s) inserted.
insert into t2 (id, t1_id) values (3,2)1 row(s) inserted.
select *
from (
select id, DBMS_RANDOM.VALUE as c_value
from t1) aa
left outer join t2
on t1_id = aa.id| ID | C_VALUE | ID | T1_ID | 1 | .28087395591452098340503336357121758754 | 1 | 1 | 1 | .0411013321995269951065052624011412747 | 2 | 1 | 2 | .89435286470554779960184785183629005997 | 3 | 2 |
|---|
select /*+ NO_QUERY_TRANSFORMATION */ *
from (
select id, DBMS_RANDOM.VALUE as c_value
from t1) aa
left outer join t2
on t1_id = aa.id| ID | C_VALUE | ID | T1_ID | 1 | .58026027330386739331811644362545741446 | 1 | 1 | 1 | .60604671223958487211422631824292832912 | 2 | 1 | 2 | .00699837094161122822784775600588998034 | 3 | 2 |
|---|
select *
from (
select /*+ NO_QUERY_TRANSFORMATION */ id, DBMS_RANDOM.VALUE as c_value
from t1) aa
left outer join t2
on t1_id = aa.id| ID | C_VALUE | ID | T1_ID | 1 | .67707311409351217968826955293837087807 | 1 | 1 | 1 | .55812596354181087399055107660893428561 | 2 | 1 | 2 | .92767093313198579614458590717700130348 | 3 | 2 |
|---|